furqan_masa
New Member
I have excel file with received and closed count for a month in a below format. how to calculate this at the end of month
eg: 1-May 2-May.... contd till 31-May
Particulars Received-Closed Received-Closed
xxx 10 10 50 50
yyy 52 35 44 58
currently iam having this formula at the end of month column:
Received closed
=C3+E3+G3+I3+K3+...cont =D3+F3+H3+J3+L3+....cont
Is there any other way to calculate this ?? i think we can't use sumifs here because we have similar columns like received and closed for every particular activity
Please advise..
Thanks
eg: 1-May 2-May.... contd till 31-May
Particulars Received-Closed Received-Closed
xxx 10 10 50 50
yyy 52 35 44 58
currently iam having this formula at the end of month column:
Received closed
=C3+E3+G3+I3+K3+...cont =D3+F3+H3+J3+L3+....cont
Is there any other way to calculate this ?? i think we can't use sumifs here because we have similar columns like received and closed for every particular activity
Please advise..
Thanks