=SUMIF(C1:C5,"<1E100")/2

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stylissimo" wrote in message
...
oh one thing, though the formula is working but i just have one concern,
if i
will use this range "C1:C5", it will add all valid values under this
column,
including the prices of each items, right? I just want to add the values
under "Gross Total" only...how will i do that?

"T. Valko" wrote:

Try this:

=SUMIF(C1:C5,"<1E100")

--
Biff
Microsoft Excel MVP


"stylissimo" wrote in message
...
if this is my spreadsheet:

A B C
1 Item 4 bags #n/a

2 Gross Total------------------ #n/a

3 Item 3 Cosmetics 1985.00

4 Item 3 Cosmetics 1500.00

5 Gross Total------------------ 3485.00

6 GRAND TOTAL-------------- "XXXXXXXXXX" <----this is the part that
i
want to know. HOw do i use SUMIF to get the grand total of all gross
total
automatically (leaving the #n/a values)