# newbie needs help with stupid formula

#### bigdogpile64

##### New Member
Or stupid newbie needs help with formula hahahaha.
I'm new to excel. I need help (and I've searched forums first) how to add an entire column to a formula I can get it to work for one row but not the rest.
for example: on the invoice template I customised it somewhat.
As I add dollar amounts to each row there are 2 seperate tax lines to be calculated after the subtotal. I've tried using for column M ....M19:M74
and other variations can't get it right. Help isn't much help to me either when I'm not sure what I'm looking for. This is probably a simple thing.
When replying please keep in miund I'm new. Thanks for any help.

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
welcome to the board!!

if your summing a whole column, like M, can't you use "=sum(M:M)"

or am i just not understanding your question?

Hi there:

Welcome to MrExcel Board!

Please describe clearly what you are working with and what you are trying to accomplish.

You have several issues embedded in your post. I will suggest, you tackle one thing at a time.

Um, I probably didn't explain it well, here's the current formula,BTW this is great you can actually copy and paste on this forum!!
=IF(AND(M75<>"",\$M19<>""),ROUND(L76*\$M19,2),"")
What I need to do is create a formula to multiply 2 different types of tax
cumlatively. that also totals all lines in the column. At this point it only calculates the tax for line 19.

Um, I probably didn't explain it well, here's the current formula,BTW this is great you can actually copy and paste on this forum!!
=IF(AND(M75<>"",\$M19<>""),ROUND(L76*\$M19,2),"")
What I need to do is create a formula to multiply 2 different types of tax
cumlatively. that also totals all lines in the column. At this point it only calculates the tax for line 19.

Um, I probably didn't explain it well, here's the current formula,BTW this is great you can actually copy and paste on this forum!!
=IF(AND(M75<>"",\$M19<>""),ROUND(L76*\$M19,2),"")
What I need to do is create a formula to multiply 2 different types of tax
cumlatively. that also totals all lines in the column. At this point it only calculates the tax for line 19.

Wow, really sorry about the multiple posts, I don't know how that happened????
computer started acting REALLY sluggish almost suspended like. had to disconnect internet (dialup) and log on again

As requested earlier, please describe what are you working with, providing ...

1. a little background on what do the numbers in cells of columns L and M represent

2. what are you charging the tax on? which cell houses that transaction amount?

3. which cells house the two tax rates that you want to apply to the transaction amount?

4. what are the two taxes for? and are both of them to be applied at the same time?

5. and let us leave the question regarding summing the whole column (we don't know what that is about) at this time

Actually if you can post your sample data using HTMLmaker (Colo's Cool utility) downloadable from MrExcel page -- it will make things a whole lot easier to understand.

ok I'll try that it'll take some time, but thanks for the reply. I'll be back

Ok. I can't find the html maker on any page , maybe I'm looking in the wrong place???

Replies
1
Views
89
Replies
4
Views
132
Replies
6
Views
173
Replies
9
Views
324
Replies
4
Views
144

1,203,170
Messages
6,053,866
Members
444,690
Latest member
itgldmrt

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back