M
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
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