I need a formula to sum numbers based on criteria on the left side of the number.

Hi guys.

I would be able to get this done with SUMIF if my setting were a little bit different, but I need it in this particular way, and SUMIF doesn't get it done.
Please see attachment. In Cell P2, I need a formula to count all "VD" in the cell range B2:O2, and then sum the number that is on the right side next to all cell containing "VD". For example for the cell range B2:02, there are three cells containing "VD" and the sum of the cells right next to them is 24 (3x8), so the value in cell P2 should be 24.

Any help would be appreciated.

Thanks

Ohh...that was my mistake
I had the formula =SUMIF(B2:N2,"VD",B2:O2)
and it would always turn out 0.

Thank you!

at P2 array formula (CSE)

=SUM(IF(TRIM(A2:N2)="VD",B2:O2))

copy down

Please refer to the file.

In it I suggested 2 distinct ways to attain your desired sum.
The first one relies on the formula to the right of the table. In short, it is a series of if()s for each cell,
The second solution is a macro that will give you the table that starts on line 10. It will count all different entries.