Bretai2k

Junior Member

Posts: 5

How to get SUM of range of cells based on two separate dropdown selections.

I have 2 dropdowns (A2 and B2) on sheet 1 that both reference cells B2 through B75 on sheet 2. I want to be able to do a SUM of all cells in the B column of sheet 2 between what I select in dropdowns A2 and B2.

I can provide examples if this is not clear enough.

TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Filter range based on results of multiple selections in a listbox	Mctabish[_4_]	Excel Programming	0	January 9th 09 07:57 AM
multiple dropdown selections	Oct1196	Excel Worksheet Functions	3	September 6th 07 05:38 PM
Help with dropdown boxes and preset selections	Keving	Excel Programming	2	July 7th 06 06:12 PM
How can I allow users to make multiple selections from a dropdown.	Liz	Excel Worksheet Functions	0	February 17th 05 05:21 AM
Dropdown Selections in Excel - creating and choosing	Abi	Excel Worksheet Functions	2	January 7th 05 02:27 AM

All times are GMT +1. The time now is 07:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us