I have a table of data with these columns:
Customer Actual Sales Target Sales
I want to calculate an overall total sales value at the top of the spreadsheet for customers where Actual Sales/Target sales is above 70%.
Do I use sum product, sumif or an array formula? Any help would be...