Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 605

SUMIF - Sum_Range is misleading

A2:A5 = 100, 200, 300, 400 respectively.
B2:B5 = 5, 15, 30, 40 respectively.
A1 and B1 are both blanks.

=SUMIF(A2:A5,"300",B2:B5) yields 30. Okay.

I know I shouldn't do the following but if I have a typo, I prefer Excel to give me an error ......

This is confusing.

=SUMIF(A2:A5,"300",B1:B2) yields 15. ??? B1 = blank and B2 = 5.
=SUMIF(A2:A5,"300",B2:B3) yields 30. ??? B2 = 5 and B3 = 15.
=SUMIF(A2:A5,"300",B3:B4) yields 40. ??? B3 = 15 and B4 = 30.

I rather have an error telling me of uneven range.

Any comments?

Epinn

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
How to use SUMIF function with non-adjacent cells	KLaw	Excel Worksheet Functions	5	October 19th 06 10:15 AM
SUMIF function help	PO	Excel Worksheet Functions	1	June 1st 06 09:33 AM
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

All times are GMT +1. The time now is 10:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us