View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 108
Default Can this Formula be Shortened Please

Hi Everyone,

Is there a Simplified Solution to this Formula Please :-

=COUNTIF(E32:J32,E31)+COUNTIF(E32:J32,F31)+COUNTIF (E32:J32,G31)+COUNTIF(
E32:J32,H31)+COUNTIF(E32:J32,I31)+COUNTIF(E32:J32, J31)

I have tried Several Alternatives 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!