1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I count the amount of cells which has a number in it in two columns but not count it twice?

For example, count it if it has a number in A1 but not count it again if there is a number in B1? Hope that makes sense.

submitted by /u/Ok-Strategy6708
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#count
#number
#cells
#A1
#B1
#columns
#twice
#example
#not count
#amount
#has
#submitted
#user
#reddit
#strategy