"NAME" formula error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2003
Deleted some columns in apreadsheet and they now go from "M,N,O" to :AZ,AY"

Trying to multiply "AZ" times 75% and subtact "AY".
Formula input i have now is:
=SUM(AZ* 0.75)-(AY)

I am getting "NAME" error message that it doesn't recognize AZ or AY?
How do i fix this?
 
It's assuming that AZ and AY are named ranges. I'm not exactly sure what
you want. If you want to multiply the sum of column AZ by .75, you need

=SUM(AZ:AZ)*.75

I'm not sure what you want to do with AY.

HTH,
Barb Reinhardt
 
Back
Top