Add only the cells after a particular number in the previous cell in the same column

D

DrSues02

Also, using the formula that you stated above for the Y's and N's.

I am using =SUMPRODUCT((Purdue!D2:D1000="Y")*(Purdue!D3:D1001="N")) t
figure out the number of times a Y immediately follows a N.

However, once again, I am trying to find a percentage. I need to fin
the number of times a Y immediately follows a N (which is the formul
above) divided by the total number of times a N occurs with either a
or N afterwards.

Here is the basic formula:

# of times a N is followed by a Y/(# of times an N is followed by a
or N)

Any ideas
 

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

Top