Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |