Bug in help for Excel SUMIF function

[Dave]

There is a bug in the help section for function SUMIF. Last line says "Sum
of the commissions for property values over 160000 (21,000)" but it should
say "Sum of the commissions for property values equal to 300000 (21,000)".

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Bernard Liengme]

In XL 2002 and XL 2003 the Help file says
=SUMIF(A2:A5,">160000",B2:B5) Sum of the commissions for property
values over 160000 (63,000)

This looks fine to me; what version are you using?

 

[Dave]

I'm using XL 2003. The third line says:

=SUMIF(A2:A5,"=300000",B2:B3) Sum of the commissions for property values
over 160000 (21,000).

That is incorrect.

 

[Gord Dibben]

Dave

I'm using Xl2003 and this is what mine reads under Help "sumif">sumif function

=SUMIF(A2:A5,">160000",B2:B5) Sum of the commissions for property values over
160000 (63,000)

You got ripped off on your Help files<g>

Which third line are you referring to?


Gord Dibben Excel MVP