Formula In Cell L2 For Cells L2 To L For Computing Number Of Instances Of G1 G2 G3 Multiplied By Corresponding Number Of Days In Cells I2 To I4

                      Google Spreadsheet   Post  #1761
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-13-2014
post by Colder Pressed:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/i7Xz8EqDCP0)
How do I count data multiple times based on a multiplier?

Hello All,

Here's what I have:

Product	Breakdown							Days		Item	Total
1 CC (L2)	G1	F2	G4	F4	G1	G3		1		G1	3
1 CC (CUSTOM)	G3	G3	G4	G4	G5	G5	R6	1		G2	0
2 CC (L1)	G3	F2	G1	F4	R1	N1		2		G3	4

Let's say Product is col. A and Total is col. M

In col M I'm using

=COUNTIF


in order to get the number of times each item appears in the table

However I'd like all the entries in 'Breakdown' to be counted twice, as dictated by the value in the 'Days' column. So in reality, the count value for 'G3' should be 5, not 4. Likewise, the total value for 'G1' should be 4, not 3.

Here's what I want to do:

Product	Breakdown							Days		Item	Total
1 CC (L2)	G1	F2	G4	F4	G1	G3		1		G1	4
1 CC (CUSTOM)	G3	G3	G4	G4	G5	G5	R6	1		G2	0
2 CC (L1)	G3	F2	G1	F4	R1	N1		2		G3	5

Is something like that possible?

Thanks in advance for any replies :) 

--------------------------------------------------------------------------------------------------------------------