View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sweetsue516
 
Posts: n/a
Default Need a total for column

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