"NAME" formula error

R

ritzput

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?
 
B

Barb Reinhardt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 'NAME" error" 5
Multiply Corresponding Values in Range 3
Any idea how to work? 0
Locking a one row headline in Col A to a 4 row body of text in Col B? 2
work this out? 0
My words and excel file are not opening as it should be 1
NFL spreadsheet 3
Error: If Range("AZ" & intCounter).Text = "" Then 7

Top