View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default 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