Thread: Formulas withing Formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Formulas withing Formulas
On Tue, 16 Aug 2005 13:58:03 -0700, Darren
wrote:

The formula works great when I made an example, but how do I change the
formula it if the volume is in G2 and the columns are G5:G22?


=SUMIF(G5:G22,"="&1.1*G2)/COUNTIF(G5:G22"="&1.1*G2)


--ron
Reply With QuoteReply With Quote