SUMIF function for multiple worksheets

S

Steve

Hi,
I have following formula, that is work with single
worksheet.
=SUMIF(F1:F100,P1,H1:H100)
My intention is to sum cell Hxx when cell Fxx == cell P1

How to do it if my data is in multiple sheets?
The following does not seem to work.

=SUMIF('Sheet1:Sheet2'!F1:F100,P1,'Sheet1:Sheet2'!
H1:H100)
I get the #Value! error

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting of sumif formula. 2
SUMIF with multiple criteria 5
SUMIF over multiple spreadsheets 4
Sumif across Multiple sheets 2
Have the SUMIF result (formula) on a separate sheet/tab 2
Summing over multiple worksheets 1
Summing across multiple worksheets in excel 2007 3
Countif and sumif combination problem 2

Top