Awesome! Perfect! that works just like I was hoping for! Thank You Soo
Very much! Now If I only understood how you did it. :/


Thanks Very Much!

Rob


"Domenic" wrote:

Try...

=SUMPRODUCT(--(SUBTOTAL(9,OFFSET(AC2:AM100,ROW(AC2:AM100)-ROW(AC2),0,1))=
10))

Adjust the range accordingly.

Hope this helps!

http://www.xl-central.com

In article ,
Rob wrote:

I am trying to figure out how I can count the number of rows where Columns
AC:AM=10 when added together no matter what numbers/integers are in any of
those columns per row.


I'm certain that it is starring me in the face and laughing at me but seeing
as it's been an extremely long day I just cannot figure it out.

Can anyone please help me?


Thanks in Advance!
Rob