Help with multiple criteria formula!
I'm trying to do a difficult job here but the best way to explain it is as the end goal we want a display dashboard that shows a % of where our current sales and invoice are for the month live so it doesn't need to be manually updated so when we add rows it doesn't need maintenance and converted to percentage to goal.
We have a master sheet which has a column for the invoiced amount, the date and a column that calculate if the invoice is this month and return true
We have another which has the sales date, the amount of $ on the sale and another to calculate if it is that month.
Im trying to get this to show as a chart on a dashboard showing how close we are to the target.
Any help is appreciated thanks!
Help Article Resources
Check out the Formula Handbook template!