Microsoft Office Forums Multiple criteria in SUMIF?
 Register FAQ Search Today's Posts Mark Forums Read

#1
02-16-2006, 06:55 AM
 pumpkin head Novice Join Date: Feb 2006 Posts: 1
Multiple criteria in SUMIF?

Hi, I'm after some help regarding SUMIF.

Basically I want to add up all of the numbers in column O that have a 100 in column A, and a 6 in column D.

I can do this separately like so:

SUMIF(A:A,100,O:O)

and

SUMIF(D: D,6,O:O)

but that doesn't help me, because I want to filter out any row which doesn't have a 100 in A and a 6 in D.

Any help would be appreciated.

PH.
#2
02-17-2006, 09:06 AM
 adbarnes Novice Join Date: Jan 2006 Posts: 9
Try this:

Create a total based on multiple conditions
Use the following formula to calculate the total value of cells F5:F25, where B5:B25 contains "Northwind" and the range C5:C25 contains the region name "Western".

=SUM(IF((B5:B25="Northwind")*(C5:C25="Western"),F5 :F25))

To calculate the total value of cells F5:F25, where B5:B25 contains either "Northwind" or "Terra Firm", use the following formula.

=SUM(IF((B5:B25="Northwind")+(B5:B25="Terra Firm"),F5:F25))

Both of these formulas are array formulas and must be entered by pressing CTRL+SHIFT+ENTER. Learn about array formulas.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Cabbage1031 Outlook 0 05-23-2007 10:56 AM wbiggs2 Excel 0 11-30-2006 01:02 PM AdamNT Excel 1 08-11-2006 11:51 PM jvieille Misc 1 02-11-2006 06:26 AM stormin.norm Outlook 0 01-30-2006 01:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top