Brickinnit
New Member
- Joined
- Aug 6, 2018
- Messages
- 3
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