Forum Discussion
countifs only if a different cell is blank
I need to create a formula that will countif ONLY if a previous cell is blank. For example, I only want it to countif there is a winter-spring score. If there is a fall score, then I don't want it to count a winter-spring score. I am trying to use something like =IF(G5:G34="","",COUNTIFS(H5:H34,"P",I5:I34,"P"))
| Fall Proficiency | Winter Proficiency | Spring Proficiency |
| P | P | P |
| P | P | |
| P | PP | PP |
| HP | HP | HP |
| # Students Moved into P Fall-Spring | 1 | 14% |
| # Students Moved into HP Fall-Spring | 1 | 14% |
| # Students Moved into P Winter-Spring | #VALUE! | #VALUE! |
| # Students Moved in to HP Winter-Spring | 1 | 14% |
| Total | #VALUE! | #VALUE! |
