Hi all,
I am trying to calculate the number of sales by customer type across a given period, and am having issues with the third criteria of my sumifs formula - specifically how to type it.
The issue is I have a table will all customer names, and over the years these change from priority 1 - 15. I wish to calculate the amount of sales of priority 1 customers in the USA in 1970 for my data set, for instance - but how can I link the sum if formula to this table to check if this customer name is priority 1?
Do I need to use a sum product?
Thank you very much
I am trying to calculate the number of sales by customer type across a given period, and am having issues with the third criteria of my sumifs formula - specifically how to type it.
- First criterion - Year of sale
- Second criterion - Country
- Third criterion - Customer name is one of the names which is classified in another list as being 'Priority 1 customer'
The issue is I have a table will all customer names, and over the years these change from priority 1 - 15. I wish to calculate the amount of sales of priority 1 customers in the USA in 1970 for my data set, for instance - but how can I link the sum if formula to this table to check if this customer name is priority 1?
Do I need to use a sum product?
Thank you very much