SumIf across multiple worksheets

A

Alberta Rose

I have 13 worksheets I want to sum quarterly. The formula I've been trying
is:

=SUMIF(A5:A36,"136982",'Apr 4:Jun 27'!G5:G36) but I get a #Value! error
message.

In column A I have contract numbers. In column G is the crew size. I want
to sum all the crew size based on specific contract numbers.

Any help is appreciated :)
 
B

Bernard Liengme

In each of the other worksheet, are the contact numbers also in column A?
best wishes
 
B

Bob Phillips

Put the 13 sheet names in M1:m13 and use#

=SUMIF(INDIRECT("'"&M1:M13&"'!A5:A36"),"136982",INDIRECT("'"&M1:M13&"'!G5:G36"))
 

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

Summing over multiple worksheets 1
Total weekly worksheets to quarterly 0
V Lookup between worksheets in same file 5
Using the INDIRECT function across multiple worksheets 0
SUMIF using date ranges & referencing account numbers 1
SUMIF over multiple spreadsheets 4
Does SUMIF work over multiple worksheets? 18
SUMIF across 2 columns. 0

Top