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

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

"S Muzumdar" wrote:

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

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


"S Muzumdar" <S wrote in message
...
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

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)

"S Muzumdar" <S wrote in message
...
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

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


"S Muzumdar" <S wrote in message
...
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