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

COUNTIF function AND only include rows that have data in previous columns

Can anyone help with the following formula please.

I currently have the following statement that provides a count of all rows that have no text in column F.

=COUNTIFS(F10:F, "")

How can I update this to only consider the row to be counted when at least one of the previous columns has some data. (So when columns A-E are not all empty for that row)

Thanks

submitted by /u/Immediate-Web4294
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com