SUMIF(sheet1:sheet4!$B$2, "Yes", sheet1:sheet4!$A$2)

Are those your real sheet names?

If you have only 4 sheets involved:

=(Sheet1!B2="yes")*Sheet1!A2+(Sheet2!B2="Yes")*She et2!A2+(Sheet3!B2="Yes")*Sheet3!A2+(Sheet4!B2="Yes ")*Sheet4!A2

--
Biff
Microsoft Excel MVP


"JeffPlax" wrote in message
...
Let me clear this up a little...

I want to use SUMIF like this

SUMIF(sheet1:sheet4!$B$2, "Yes", sheet1:sheet4!$A$2)

but it gives me the dreaded #VALUE

"JeffPlax" wrote:

I have a series of spreadsheets, and I need to sum the hours only if they
are
billable

column A contains hours, and column B indicates weather hours in column A
are billable or not (Yes or No). Does SUMIF work using 3D-references?