SUMIF in multiple worksheets

[Mike]

Hi

I am trying to write a SUMIF calculation that will add up
a number of costs when they correspond to a code in
another column. I can get it to work on a single sheet but
not to total mny. I get a #VALUE! response.

EG: Column AL contains the cost I want to sum, Column K
contains the code and the code that I want the sum to
match is in a table and appears in Column N.

The formula that I am using for a single sheet is:

=SUMIF($K$5:$K$206,$N209,AL$5:AL$206)

The formula that I am using for the multiple sheets is:

=SUMIF(Clin1:Clin15!$K$5:$K$206,$N220,Clin1:Clin15!
$AL$5:$AL$206)

I have tried adding in ' ' either side of the sheet name
but it removes them.

I would really appreciate some advice.

Thianks

Mike

 

[Harlan Grove]

I am trying to write a SUMIF calculation that will add up
a number of costs when they correspond to a code in
another column. I can get it to work on a single sheet but
not to total mny. I get a #VALUE! response.

....

http://groups.google.com/groups?selm=eGQWB66yCHA.2684@TK2MSFTNGP11