Try this...

=SUMIF(Transactions!L:L,"object #555",Transactions!F:F)

--
Biff
Microsoft Excel MVP


"luttona" wrote in message
...
I've used SUMPRODUCT in the past but wasn't sure if it was needed in this
case.

Specifically, I need the total costs (in column F of the worksheet
"TRANSACTIONS") of all entries coded as object #555 (in column L of the
same
worksheet "TRANSACTIONS") to appear in a cell in the worksheet "TOTALS".

It seemed a simple case of using SUMIF, but it wasn't working like I
thought
it would, which is what prompted my original question.

Any help would be appreciated, and thank you!

"Jacob Skaria" wrote:

'SUMIF with multiple sheets...SUM ColB IF ColA match with cell C2 of
current
sheet
=SUMPRODUCT(SUMIF(INDIRECT("'"& {"sheet1","sheet2"} &"'!A:A"),C2,
INDIRECT("'"& {"sheet1","sheet2"} &"'!B:B")))

'If you have more sheets names as Sheet1,Sheet2,Sheet3 ....Sheet25 try
=SUMPRODUCT(SUMIF(INDIRECT("'"&"sheet"&ROW(INDIREC T("1:25"))
&"'!A:A"),C2,INDIRECT("'"&"sheet"&ROW(INDIRECT("1: 25"))&"'!B:B")))

If this post helps click Yes
---------------
Jacob Skaria


"luttona" wrote:

I'm trying to create a summary worksheet involving figures from other
worksheets, but SUMIF is giving me problems. I'd heard that SUM works
over
multiple worksheets, but does SUMIF?