## Saturday, September 13, 2014

### 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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-13-2014
post by Colder Pressed:
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 :)
--------------------------------------------------------------------------------------------------------------------