View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Paul Black[_2_] Paul Black[_2_] is offline
external usenet poster
 
Posts: 112
Default Help with Totals Please

Hi Steve,

One Final Question Please,
I am Using the Formulas …
Q2 ="$J$" & COLUMN()-14 & ":$O$" & COLUMN()-14
Q3 =COUNT(MATCH(INDIRECT(Q$2),$C3:$H3,0))
… and they Work Great.
However, I Inserted 5 Extra Lines at the Top of the Sheet and the
Formula ="$J$" & COLUMN()-14 & ":$O$" & COLUMN()-14 Doesn't Seem to Work
Anymore. I have Tried Changing Different things But to NO Avail.

Thanks in Advance.
All the Best.
Paul



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!