If you want only the "gross totals" added:

Try this array formula** :

=SUM(IF((A1:A5="gross total")*(ISNUMBER(C1:C5)),C1:C5))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


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