Yes, but the sum will get double the value, the sum of the individual items,
and the sum of the totals. So just divide by 2 as I showed.

--
HTH

Bob

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

"stylissimo" wrote in message
...
i can't use this formula because i will be including the prices of each
items...i just want to filter the valid values on column C under "Gross
Total" and sum it up to get the grand total of it automatically

"Bob Phillips" wrote:

=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)