Forum Discussion
Combining If and Lookup Functions calculating some cells but not all
Hello, I am having an odd issue with Excel that I cannot seem to find the answer to by searching Google. I have a function that has several if functions, index/match, and lookup functions. The f...
Enter this formula in Column P, starting with P3:
=COUNTIF(Q$3:Q3,Q3)
=COUNTIF(Q$3:Q3,Q3)
Twifoo wrote:
Enter this formula in Column P, starting with P3:
=COUNTIF(Q$3:Q3,Q3)
I am not sure how this formula helps me. If there is a value in Q then P should show 0 because the item has been counted. For the blanks in Q P should have a number between 1 and x depending on how many A, B, or C items there are per week for the location. When it hits x the next number needs to be 1 to start a new week. The formula I have works. Excel just does not want to calculate the cells 100% of the time so it throws off my week counts, and that is what I want to find a solution for.
- Your statements are contradicting so I can’t understand what you really want to achieve.