SumIf across multiple worksheets
 

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 :)

SumIf across multiple worksheets
 

In each of the other worksheet, are the contact numbers also in column A?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Alberta Rose" wrote in message
...
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 :)

SumIf across multiple worksheets
 

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

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

---
HTH

Bob Phillips

"Alberta Rose" wrote in message
...
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 :)