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

Hi

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

Andy.

"ExcelBob" <ExcelBob.29e8rk_1150291240.7517@excelforum-nospam.com> wrote in
message news:ExcelBob.29e8rk_1150291240.7517@excelforum-nospam.com...
>
> 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=551845
>

Look in Help for SUMIF
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ExcelBob" <ExcelBob.29e8rk_1150291240.7517@excelforum-nospam.com> wrote in
message news:ExcelBob.29e8rk_1150291240.7517@excelforum-nospam.com...
>
> 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=551845
>