View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Define cell as a condition

=sumif(a:a,""&x17,b:b)
or
=sumif(a:a,x17,b:b)





Alexandra Lopes wrote:

Hello,

I'm using the Conditional Sum Wizard.I want to set a condition
indicating a cell and not a value. How do I do it?

Thanks in advanced.

Alexandra


--

Dave Peterson