 |
| Author |
Message |
Narcis
|
 Posted: Tue May 22 09:26:00 CDT 2007 |
Top |
worksheet functions >> Criteria in sum if ?
I want to reference another cell in the criteria for sumif - look at the
example below - can this be done ?
=SUMIF(B1:B10,"<C1",A:A10)
In the criteria section if I have an argument like "<1,000", for eg., it
works, but if I refer it to another cell it doesn't work. Do you have any
suggestions ?
Thanks,
Shailesh Muzumdar
Excel344
|
| |
|
| |
|
BarbReinhardt
|
| Posted: Tue May 22 09:26:00 CDT 2007 |
Top |
worksheet functions >> Criteria in sum if ?
I prefer to use SUMPRODUCT, but there may be a reason to use SUMIF for this
=SUMPRODUCT(--(B1:B10<C1),(A1:A10))
HTH,
Barb Reinhardt
> I want to reference another cell in the criteria for sumif - look at the
> example below - can this be done ?
>
> =SUMIF(B1:B10,"<C1",A:A10)
>
> In the criteria section if I have an argument like "<1,000", for eg., it
> works, but if I refer it to another cell it doesn't work. Do you have any
> suggestions ?
>
> Thanks,
> Shailesh Muzumdar
>
|
| |
|
| |
|
Peo
|
| Posted: Tue May 22 09:45:40 CDT 2007 |
Top |
worksheet functions >> Criteria in sum if ?
Try
SUMIF(B1:B10,"<"&C1,A:A10)
In your example it looks for the string C1 and not the cell
--
Regards,
Peo Sjoblom
>I want to reference another cell in the criteria for sumif - look at the
> example below - can this be done ?
>
> =SUMIF(B1:B10,"<C1",A:A10)
>
> In the criteria section if I have an argument like "<1,000", for eg., it
> works, but if I refer it to another cell it doesn't work. Do you have any
> suggestions ?
>
> Thanks,
> Shailesh Muzumdar
>
|
| |
|
| |
|
Bob
|
| Posted: Tue May 22 09:47:46 CDT 2007 |
Top |
worksheet functions >> Criteria in sum if ?
=SUMIF(B1:B10,"<"&C1,A:A10)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
>I want to reference another cell in the criteria for sumif - look at the
> example below - can this be done ?
>
> =SUMIF(B1:B10,"<C1",A:A10)
>
> In the criteria section if I have an argument like "<1,000", for eg., it
> works, but if I refer it to another cell it doesn't work. Do you have any
> suggestions ?
>
> Thanks,
> Shailesh Muzumdar
>
|
| |
|
| |
|
Roger
|
| Posted: Tue May 22 10:06:35 CDT 2007 |
Top |
worksheet functions >> Criteria in sum if ?
Hi
Try
=SUMIF(B1:B10,"<"&C1,A1:A10)
With ">C1" you were asking SUMIF to look for literally <C1 in cells, as
all was included within the quotes.
(You original formula was also missing a 1 after the first A which was
obviously just a typo).
--
Regards
Roger Govier
>I want to reference another cell in the criteria for sumif - look at
>the
> example below - can this be done ?
>
> =SUMIF(B1:B10,"<C1",A:A10)
>
> In the criteria section if I have an argument like "<1,000", for eg.,
> it
> works, but if I refer it to another cell it doesn't work. Do you have
> any
> suggestions ?
>
> Thanks,
> Shailesh Muzumdar
>
|
| |
|
| |
|
| |
|