newbie needs help with stupid formula

[bigdogpile64]

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.

 

[Zack Barresse]

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?

 

[Yogi Anand]

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.

 

[bigdogpile64]

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.

 

[bigdogpile64]

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.

 

[bigdogpile64]

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.

 

[bigdogpile64]

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

 

[Yogi Anand]

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.

 

[bigdogpile64]

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

 

[bigdogpile64]

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