"sumif" function

[MARKEGANDERSON]

Hello All,

How would I sum an addition column for my Sumif Function?

Here's my scenario:

=SUMIF(G13:G62,F4,H13:H62)

I also want the sum of J13:J62, with the same above criteria-

Can I combine 2 Sumif functions?

or can i add something in the above formula to calculate both columns?

Thanks!

 

[Aladin Akyurek]

Hello All,

How would I sum an addition column for my Sumif Function?

Here's my scenario:

=SUMIF(G13:G62,F4,H13:H62)

I also want the sum of J13:J62, with the same above criteria-

Can I combine 2 Sumif functions?

or can i add something in the above formula to calculate both columns?

Thanks!

Either:

=SUMIF(G13:G62,F4,H13:H62)+SUMIF(G13:G62,F4,J13:J62)

Or, control+shift+enter, not just enter...

=SUM(IF(G13:G62=F4,H13:H62+J13:J62))

 

[MARKEGANDERSON]

Thank You!