Posted to microsoft.public.excel.misc

Lamb Chop

external usenet poster

Posts: 38

the proper use of sumif

How can I sum B1:B33 if A1:A33 is in between 50 and 70 ?

I have tried this, but I only got 0

=SUMIF(A1:A33, "AND(50, <70)", B1:B33)

Thanks

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
How to use SUMIF to return sums between two values located in cells	ScottBerger	Excel Worksheet Functions	2	April 23rd 23 09:05 PM
Sumif of Sumif perhaps?	Fred	Excel Discussion (Misc queries)	2	March 29th 06 05:39 PM
SUMIF	Ferg	Excel Worksheet Functions	3	February 28th 06 03:37 AM
SUMIF with Mutiple Ranges & Criteria	PokerZan	Excel Discussion (Misc queries)	5	August 4th 05 10:31 PM
Using PROPER for Columns, rows or ENTIRE spreadsheet	Tom	Excel Worksheet Functions	3	February 4th 05 03:43 PM

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

About Us

"It's about Microsoft Excel"