hello I have spent so much time trying to figure out index, match, vlookup aghhhh .
I am trying to:
1.
Make a dynamic sheet in that i can keep adding dates and data and it will keep calculating in the summary monthly and yearly...
2.
Include a Tax rate of 15 cents to every dollar and only calculated when column F has "Invoice" selected.
Have tried vlookups but dont know how to look up if invoice, if "film etc..
I dont even know if i have the structure right, please feel free to change anything to simplify it. Any advise as I really am trying to learn all the formulas...
Is
Bookmarks