software

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,quot;JANquot;,'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

=SUMPRODUCT(--('Sales Ledger'!B1:B100=quot;JANquot;),--('Sales Ledger'!C1:C100=quot;Tool
Hirequot;),'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)

quot;David Harrisonquot; gt; wrote in message
...
gt; Hi There
gt;
gt; I currently have the function that works fine but i need to put another
gt; argument into it and i am struggling.
gt; Currently:
gt;
gt; =SUMIF('Sales Ledger'!B:B,quot;JANquot;,'Sales Ledger'!F:F)
gt;
gt; However, on the Sales ledger page i have another box with different
details
gt; in. The is in Colum C:C and the current details is Tool Hire.
gt;
gt; How do i get the query to only add up the sum if cell Colum B has JAN and
gt; Colum C has Tool Hire.
gt;
gt; Thanks
gt;
gt; David
=SUMPRODUCT(('Sales Ledger'!B1:B65536=quot;JANquot;)*('Sales Ledger'!C1:C65536=quot;Tool
Hirequot;),'Sales Ledger'!F1:F65536)

SUMPRODUCT doesn't like whole columns!

HTH
--
AP

quot;David Harrisonquot; gt; a écrit dans le
message de news: ...
gt; Hi There
gt;
gt; I currently have the function that works fine but i need to put another
gt; argument into it and i am struggling.
gt; Currently:
gt;
gt; =SUMIF('Sales Ledger'!B:B,quot;JANquot;,'Sales Ledger'!F:F)
gt;
gt; However, on the Sales ledger page i have another box with different
gt; details
gt; in. The is in Colum C:C and the current details is Tool Hire.
gt;
gt; How do i get the query to only add up the sum if cell Colum B has JAN and
gt; Colum C has Tool Hire.
gt;
gt; Thanks
gt;
gt; David