Forum Discussion
Solved
Trouble with a formula in EXCEL
I am attempting to search a sheet with three particular columns of interest: and I want to count up the number of instances that match … the last check is for a blank cell, and I can not see to get ...
by typing "isblank" it is checking if the cell contents say that text. Try using "" instead.
BTW you do know that countifs treats those conditions with an AND logic and therefore all those conditions must be true and not OR. I think that is what you want but wanted to mention it.
maybe attach the sheet.
to debug I would check each condition individually to make sure it is pointing to the correct range and values. Also, are cells in col F blank or have spaces?
to debug I would check each condition individually to make sure it is pointing to the correct range and values. Also, are cells in col F blank or have spaces?