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?