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

Contexta · Mar 21st, 2002, 10:35 PM

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 · Mar 21st, 2002, 10:45 PM

Quote:

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 · Mar 22nd, 2002, 07:58 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 10:35 PM	#1
Contexta New Member Join Date: Mar 2002 Location: Nancy Posts: 2	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!

Mar 22nd, 2002, 07:58 AM	#3
Contexta New Member Join Date: Mar 2002 Location: Nancy Posts: 2	Thank you! I guess their really are some simple things in excel