Is there an easier way to accumulate than using "Countif" statements

[Gr8F8]

Currently using: =COUNTIF(AD4:AS4,1)*F4+COUNTIF(AD4:AS4,2)*G4+COUNTIF(AD4:AS4,3)*H4+COUNTIF(AD4:AS4,4)*I4+COUNTIF(AD4:AS4,5)*J4+COUNTIF(AD4:AS4,6)*K4+COUNTIF(AD4:AS4,7)*L4+COUNTIF(AD4:AS4,8)*M4+COUNTIF(AD4:AS4,9)*N4+COUNTIF(AD4:AS4,10)*O4+COUNTIF(AD4:AS4,11)*P4+COUNTIF(AD4:AS4,12)*Q4. Is there an easier way? See Cells EU thru FC on the attached; I would like to keep it a spreadsheet for ease of tab use and not turn it into a database. After I can figure out a better way to do this, my next issue is printing out Invoices more efficiently than what I set up in the tabs.

 

[NARAYANK991]

Hi ,

Can you try this array entered formula , using CTRL SHIFT ENTER :

=SUMPRODUCT(($F$3:$Q$3=TRANSPOSE(R4:AC4))*($F4:$Q4))

Enter this in EU4 , and copy down.

The highlighted part is to be changed as you copy it across for the other months.

Narayan