Remember Me?

#1
October 28th 04, 09:21 PM
Can I use SUMIF with < and >?

I have a worksheet with a price field and a cost field. I am trying to sum
the cost field with the condition that the value in the price field is
between two numbers, for example, 300 and 350. Is there a formula that will
aloow me to do that?

#2
October 28th 04, 09:27 PM
 Frank Kabel Posts: n/a

Hi
one way:
=SUMIF(A1:A100,"300",B1:B100)-SUMIF(A1:A100,"=350",B1:B100)

or
=SUMPRODUCT(--(A1:A100300),--(A1:A100<350),B1:B100)

--
Regards
Frank Kabel
Frankfurt, Germany

"cursednomore" schrieb im
Newsbeitrag ...
I have a worksheet with a price field and a cost field. I am trying

to sum
the cost field with the condition that the value in the price field

is
between two numbers, for example, 300 and 350. Is there a formula

that will
aloow me to do that?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Peter Curtis Excel Discussion (Misc queries) 2 January 12th 05 02:02 PM anuita Excel Discussion (Misc queries) 1 January 4th 05 06:06 PM Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM Frank Kabel New Users to Excel 3 December 16th 04 07:23 AM TimH Excel Worksheet Functions 3 October 28th 04 08:18 PM

All times are GMT +1. The time now is 02:26 AM.