SUMIF FUNCTION

[Guest]

Hi There

I currently have the function that works fine but i need to put another
argument into it and i am struggling.
Currently:

=SUMIF('Sales Ledger'!B:B,"JAN",'Sales Ledger'!F:F)

However, on the Sales ledger page i have another box with different details
in. The is in Colum C:C and the current details is Tool Hire.

How do i get the query to only add up the sum if cell Colum B has JAN and
Colum C has Tool Hire.

Thanks

David

 

[Bob Phillips]

=SUMPRODUCT(--('Sales Ledger'!B1:B100="JAN"),--('Sales Ledger'!C1:C100="Tool
Hire"),'Sales Ledger'!F1:F100)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Ardus Petus]

=SUMPRODUCT(('Sales Ledger'!B1:B65536="JAN")*('Sales Ledger'!C1:C65536="Tool
Hire"),'Sales Ledger'!F1:F65536)

SUMPRODUCT doesn't like whole columns!

HTH