•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
#AI formula generation techniques
#formula generator
#row zero
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#COUNTIF
#IF
#IS BLANK
#formula
#count
#name
#column
#display
#blank cell
#active text