Adding Up!

E

ExcelBob

In cells A1:AH1 I have some numbers and some blanks
In cells A2:AH2 I have a pick list of letters A, S, B

When the user selects the "A" from the drop down list I want a formula
which will add the totals of the cells in A1:AH1

Any ideas?

Thanks
ExcelBob
 
G

Guest

Hi

Try this, presuming your drop-down list is in A3:
=SUMPRODUCT(--(A2:AH2=A3),--(A1:AH1))

Andy.
 
Top