Thread: How to get SUM of range of cells based on two separate dropdown selections.
View Single Post
  #1   Report Post  
Bretai2k Bretai2k is offline
Junior Member
  
Posts: 5
Default 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 QuoteReply With Quote