Hi All
I have a formula to calculate a Total. I have attached my workbook.
Formula is in F8. I need to look up the total sales for all Super 7 products.
Is there a easier way than the following:
Formula:
=SUM(SUMIF(B8:B844,"*"&"FITCH & LEEDES"&"*",D8:D844)+SUMIF(B8:B844,"*"&"F&L"&"*",D8:D844)+SUMIF(B8:B844,"*"&"MUSGRAVE"&"*",D8:D844)+SUMIF(B8:B844,"*"&"HALLS"&"*",D8:D844)+SUMIF(B8:B844,"*"&"ROSES"&"*",D8:D844)+SUMIF(B8:B844,"*"&"M/FALLS"&"*",D8:D844)+SUMIF(B8:B844,"*"&"NETTARI"&"*",D8:D844)+SUMIF(B8:B844,"*"&"HOPE"&"*",D8:D844)+SUMIF(B8:B844,"*"&"LUCY'S SUMMER GIN"&"*",D8:D844)+SUMIF(B8:B844,"*"&"300ML"&"*",D8:D844)+SUMIF(B8:B844,"*"&"JUICEBOX APPLE FIZZ"&"*",D8:D844))
Bookmarks