Adding Up!
 

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


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=551844

Adding Up!
 

"ExcelBob" wrote:
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

Assuming droplist in A4,
try in say, B4: =SUMIF(A2:AH2,A4,A1:AH1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---