•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using COUNTIF and IF IS BLANK in 1 formula
Using CountIf and If Is Blank in same formula
I’m trying to count how many times a name appears in a column, and have that number displayed on each row
My current formula is “=COUNTIF(L:L, L:2)” with this sitting in E:2
The problem is, every blank line counts the blank cells, and I want them to stay blank if there’s no text entered in cell L for that particular row.
How do I go about making sure cell E stays blank if there’s is no active text in cell L
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com