So essentially I'm making a countifs, but the issue is this. If something specific occurs then there should be an added criteria added, if not then the countifs should only have the starting criteria. I was attempting to see I can make some kind of concatenate to attach on to the formula if the if statement is true.
This example I wrote up is based around something in my excel, to make it simple, the cell to the left C2 is being checked whether it is a or not. If it is then add a range b2:b200 with criteria that it must be "N", if not don't count. However if the cell to the left is not a then just one range and criteria.
I hope I explained my issue well enough. It's essentially adding another range/criteria if a certain instance is met. If not don't add on to the formula. at first I was thinking countif + countif but I realized that just adds on to the count rather than restricts it.
Bookmarks