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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF Function	Peter Curtis	Excel Discussion (Misc queries)	2	January 12th 05 02:02 PM
SumIF	anuita	Excel Discussion (Misc queries)	1	January 4th 05 06:06 PM
SUMIF with only one criteria cell within range	Stan	Excel Discussion (Misc queries)	5	December 16th 04 10:12 PM
creiteria in sumif	Frank Kabel	New Users to Excel	3	December 16th 04 07:23 AM
SUMIF based on 2 conditions	TimH	Excel Worksheet Functions	3	October 28th 04 08:18 PM

All times are GMT +1. The time now is 05:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us