SumIF - problem with Criteria
 

=SUMIF($A$9:$A48,"<=16",D$9:D$48)

The above works.

But what I need to do is to have the "<=16" get the variable value 16 from a
cell. The cell address with the current value 16 is AH1 and is on the same
worksheet.

Sorry folks - I can't figure out how to do this. If I enter "<=16", I get
the correct value. If I enter "<=AH1", I get 0.

SumIF - problem with Criteria
 

=SUMIF($A$9:$A48,"<="&AH1,D$9:D$48)



qwerty wrote:

=SUMIF($A$9:$A48,"<=16",D$9:D$48)

The above works.

But what I need to do is to have the "<=16" get the variable value 16 from a
cell. The cell address with the current value 16 is AH1 and is on the same
worksheet.

Sorry folks - I can't figure out how to do this. If I enter "<=16", I get
the correct value. If I enter "<=AH1", I get 0.

--

Dave Peterson

SumIF - problem with Criteria
 

Try this:

=SUMIF($A$9:$A$48,"<="&AH1,D$9:D$48)

Hope this helps.

Pete

SumIF - problem with Criteria
 

Thank you. Problem solved.

"Dave Peterson" wrote in message
...
=SUMIF($A$9:$A48,"<="&AH1,D$9:D$48)



qwerty wrote:

=SUMIF($A$9:$A48,"<=16",D$9:D$48)

The above works.

But what I need to do is to have the "<=16" get the variable value 16
from a
cell. The cell address with the current value 16 is AH1 and is on the
same
worksheet.

Sorry folks - I can't figure out how to do this. If I enter "<=16", I get
the correct value. If I enter "<=AH1", I get 0.

--

Dave Peterson