Excel 2010 - Calculating totals but only on specific rows - VLOOKUP?

[Brickinnit]

Unit Name	June 2018 Instances	July 2018 Instances	August 2018 Instances	Cost (pounds)
dgfg	1			25
fgdfg		2		30
sfsdf	2			35
sdfsdgdfgfd		3		40
sdfsdf			6	45
sfsdf	3			50
sdfsdfsfdsdf		5		55
dsfsdf				60

<tbody>
</tbody>

Hi Excel Community,

This is the first time I have posted so apologies if any mistakes I did read the posting guide and already searched for a solution but no luck so far - hope you can help

Anyway, please see posted table above. I would like to quickly calculate the totals for each month (June, July then August). June total cost would be ((1X25)+(2X35)+(3X50)) = 245 pounds. July would be ((2X30)+(3X40)+(5X55)) = 455 pounds etc. I can obviously do with a simple sum of each total but if have lots of rows, this becomes rather long-winded (for example (=SUM(B3*E3)+(B4*E4) etc etc. Is there an easier way via, for example, VLOOKUP? I tried using combination of VLOOKUP, SUM, PRODUCT etc but couldn't find a way to work.

Hope this makes sense and thanks so much in advance for the help.

Brick

 

[Eric W]

Depends on how you want the results. For example:

	A	B	C	D	E
1	Unit Name	June 2018 Instances	July 2018 Instances	August 2018 Instances	Cost (pounds)
2
3	dgfg	1			25
4	fgdfg		2		30
5	sfsdf	2			35
6	sdfsdgdfgfd		3		40
7	sdfsdf			6	45
8	sfsdf	3			50
9	sdfsdfsfdsdf		5		55
10	dsfsdf				60
11
12	Sum	245	455	270

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B12 =SUMPRODUCT(B3:B10,$E$3:$E$10) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Drag right as needed.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ng-totals-but-only-specific-rows-vlookup.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Especially as you had received 3 unanswered replies, before starting this thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).