Sum If with 2 checks

Carly

Active Member
Joined
Aug 21, 2002
Messages
370
I have a column which contains either "Stocked", "NonStocked" or "Sourced", another column containing either "Manual Review", "Repatriate" or "Clearance" and another column containing a sales value.

What I would like to so is SUM the sales value field when the 1st column contains "Stocked" & the 2nd column contains "Manaul Review"...Is there any way I can do this without creating a new field with a concatenated value.

Any help would be greatly received.

Regards

Carly
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try something like:

=SUMPRODUCT(--(A1:A5="stocked"),--(B1:B5="manual review"),--(C1:C5))
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
A slight edit on NBVC's,

=SUMPRODUCT(--($A$1:$A$5="stocked"),--($B$1:$B$5="manual review"),$C$1:$C$5)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,268
Messages
5,577,102
Members
412,768
Latest member
klig
Top