View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default SUMIF ranges linked to a data validation cell

Hi,

Refer to http://www.contextures.com/xlDataval02.html

Challa Prabhu

"Steggles" wrote:

How do you link the ranges in a SUMIF formula to a another reference cell.
The reference cell would be set up as a data validation list. Your help
would be much appreciated.