Need a total for column

Giganews Newsgroups
Subject: Need a total for column
Posted by:  sweetsue516
Date: Thu, 18 May 2006

Need a formula that will calulate column F*A, but only if column F contains a
number and not text.

Help!

A    B    C    D    E    F
                    
10%    15.58    38.50    26.68    9.43    N/A
                    
10%    13.51    36.03    24.85    6.41    3.34
                    
4%    8.41    28.66    20.26    4.86    N/A
        
4%    3.67    13.86    15.75    9.89    9.20

Replies