I can do the correct function for one column but not two - H

[Contexta]

Hi, The function is: =SUMIF(A2:A26,A32,B2:B26) This works but I need to also include O2:O26 to the first part and M2:M26 to the third part and I cannot seem to get it right.

I appreciate the help!

 

[Aladin Akyurek]

On 2002-03-21 21:35, Contexta wrote:
Hi, The function is: =SUMIF(A2:A26,A32,B2:B26) This works but I need to also include O2:O26 to the first part and M2:M26 to the third part and I cannot seem to get it right.

I appreciate the help!

=SUMIF(A2:A26,A32,B2:B26)+SUMIF(O2:O26,A32,M2:M26)

 

[Contexta]

Thank you! I guess their really are some simple things in excel :wink: