Ryno --
Two problems:
1) The ranges, when I opened it were wrong, but that is probably trivial.
2) As per the help file (I just pushed the help button in the formula
wizard dialog) the enter criteria needs to be in quotes.
I am not sure what <> means, but if you are trying to say if that
criteria equal G then you would put:
=SUMIF(G7:G17;"=G";F7:F17)
Or, just modifying yours, (which gave me 0)
=SUMIF(G7:G17;"<>G";F7:F17)
HTH, and remember that the in product help is usually pretty helpful.
Peter
Ryno Labuschagne (ISS Namibia) wrote:
Hi,
Please see attached calc sheet with formula and error.
Can somebody please help me?
Thanx
Ryno Labuschagne
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
