Chalklands
New Member
- Joined
- May 17, 2018
- Messages
- 13
Hi,
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 greatly appreciated.
Thanks
Pete
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 greatly appreciated.
Thanks
Pete