Bug in help for Excel SUMIF function
 

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/comm...et.f unctions

Bug in help for Excel SUMIF function
 

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave" wrote in message
...
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/comm...et.f unctions

Bug in help for Excel SUMIF function
 

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.

"Bernard Liengme" wrote:

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave" wrote in message
...
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/comm...et.f unctions

Bug in help for Excel SUMIF function
 

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


On Wed, 16 Nov 2005 15:50:12 -0800, "Dave"
wrote:

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.

"Bernard Liengme" wrote:

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave" wrote in message
...
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/comm...et.f unctions