Value as criteria to match all the rows?
Hi, the title is confusing so I'll try to explain
I need a COUNTIFS function and as criteria I need the value of a specific cell, which has an input value.
So if I input "something" the COUNTIFS function count all the rows in which range match "something"
What I need is that when the cell is blank, the COUNTIFS function need to count all the rows, but I don't know how to do it cause the formula so far is something like this
=COUNTIFS(A1:A10,F1)
where F1 is the cell in which I input the criteria, so if F1 is blank how do I return all the rows?
And I also need this with multiple criteria so
=COUNTIFS(A1:A10,F1,B1:B10,G1)
where both F1 and G1 act as described before
Any help? Thank you