I would add another column to sum the range...for instance in AQ1 I would
enter:

=SUM(AC1:AM1)

....and copy that cell down. Now you have column you can do a simple COUNTIF
on:

=COUNTIF(AQ:AQ,10)

I'm sure there are some hefty arrays, but I like to keep the plumbing simple.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"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