SumIF - problem with Criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

qwerty - 23 May 2006 01:09 GMT

=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.

Reply to this Message

Dave Peterson - 23 May 2006 01:13 GMT

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

> =SUMIF($A$9:$A48,"<=16",D$9:D$48)
>
[quoted text clipped - 6 lines]
> 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.

Signature

Dave Peterson

Reply to this Message

qwerty - 23 May 2006 01:27 GMT

Thank you. Problem solved.

> =SUMIF($A$9:$A48,"<="&AH1,D$9:D$48)
>
[quoted text clipped - 10 lines]
>> 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.

Reply to this Message

Pete_UK - 23 May 2006 01:19 GMT

Try this:

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

Hope this helps.

Pete

Reply to this Message