SUMIF FUNCTION

S

Susan

Hello All,

Need to add a second criteria to this sumif.
=SUMIF(SHEET1!C$1:C$953,"OATS",SHEET1!H$1:H$953)
Now it is only adding dollars in col. H for any "oats" in col.C.
Would like sum of dollars if there are oats in col. C and corn in col. F.
Is this possible?

Thank you everyone!
 
P

PCLIVE

Use SUMPRODUCT.

=SUMPRODUCT(--(Sheet1!C$1:C$953="oats"),--(Sheet1!F$1:F$953="Corn"),Sheet1!H$1:H$953)

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF Function 2
Sumif using partial string 7
sumif using "AND" and "Date" 2
SUMIF and AND/OR/NOT 7
Getting a formula to reflect added columns 10
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
sumif 3
Nesting SUMIF within SUMPRODUCT 10

Top