If Formula (visible cells only)

M

MP

Need assistance editing the following if formula in excel 2003 to only show
the count for visible cells only and ignores any hidden rows.

=IF(J2=J1,K1+1,1)

The formula checks to see if the value in J2 equals J1, if true a + 1 is
added from K1 and entered into cell K2. If false the count is returned to 1.

The formula is entered K2:K2211. See below:

K2: =IF(J2=J1,K1+1,1)
K3: =IF(J3=J2,K2+1,1)
K4: =IF(J4=J3,K3+1,1)

Any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal and IF Formula 1
Word macro that can call cells out of Excel for a find and replace 0
Formula for hiest rate 7
=Sumproduct Question 0
AND IF formula 4
Formula not displaying colored border when double clicked 0
how to find text vaues for a given grade? 0
color after depending on 1st value in a cell 1

Top