• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to calculate with horizontal columns

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
 
presuming your data goes from C3 to BL3 and C3 contains the first received, D3 contains the first closed:


Enter the below formulas with Ctrl+Shift+Enter (array formulas)


Received


=SUM(IF(MOD(COLUMN($C$3:$BL$3)-COLUMN(C3),2)=0,$C$3:$BL$3,0))


Closed:


=SUM(IF(MOD(COLUMN($C$3:$BL$3),2)=0,$C$3:$BL$3,0))
 
Back
Top