Assistance with Simplified SumIf Formula

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:

Please Login or Register  to view this content.

Hi

You can use an Array for this, however you will need to amend your list of super 7 products (in Column F) to have * before and after

{=SUM(SUMIF(B:B,$F$11:$F$21,D:D))}

Do not type the curly braces yourself instead input

=SUM(SUMIF(B:B,$F$11:$F$21,D:D))

Using CTRL + SHIFT + ENTER

N.B - your list of super 7 and your text in your formula do not match up so you will get a different result using my method so please amend your list to be accurate

Hey there guys

Both Solutions will work perfectly. Thanks so much. Not sure which I'll make use of. Am only now starting to build the system.

Good luck Sintek, and glad I/we could offer some advice.

Thanks also for the rep

Hey there guys

Both Solutions will work perfectly. Thanks so much. Not sure which I'll make use of. Am only now starting to build the system.

Hey there PFDave

How would the formula look in VBA code

Hey there PFDave

How would the formula look in VBA code

Thanks Guys

Figured it out.

Please Login or Register  to view this content.