April 30th, 2010, 10:02 PM
posted to microsoft.public.excel.worksheet.functions
|
|
|
Sumif Function
On Fri, 30 Apr 2010 13:06:01 -0700, worduser
wrote:
I successfully wrote a formula to give me the sum of one column (F) based on
whether or not column D has an "x" in it. It works fine in one spreadsheet,
but when I copied and pasted it to another spreadsheet, which was virtually
identical to the first, only it had less information entered into it, I got a
"#name?" error message. Here is the formulas that works in the first
spreadsheet: =_xlfn.SUMIFS(F:F,D ,"x",F:F,"0").
Also, I don't know why there is the "_xlfn." in the front of the function -
I know I did not type it there, and why it says "SUMIFS" instead of "SUMIF"
is also beyond me.
Can anyone help?
Have a look he
http://office.microsoft.com/en-us/ex...045691033.aspx
Hope this helps / Lars-Åke
|