Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelBob
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with adding automatic data. tnnt Excel Discussion (Misc queries) 1 March 8th 06 09:42 AM
Rounding Error when adding or subtracting two cells mtheo Excel Worksheet Functions 2 February 28th 06 06:51 PM
adding vertical bars to an embedded chart using VBA Wazooli Excel Discussion (Misc queries) 0 November 15th 05 05:47 PM
help neede with adding times rvnwdr Excel Discussion (Misc queries) 1 June 17th 05 02:15 PM
problem adding rvnwdr Excel Discussion (Misc queries) 2 June 8th 05 06:36 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"