Criteria in sum if ?
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,"

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 I want to reference another cell in the criteria for sumif - look at the > example below - can this be done ? > > =SUMIF(B1:B10," > 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," > 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," > 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 I want to reference another cell in the criteria for sumif - look at >the > example below - can this be done ? > > =SUMIF(B1:B10," > 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 >