Hi there,
I'd like to COUNTA in column B if column A equals "Active".
How would I string together a formula for this?
Thanks,
Victoria
Hi there,
I'd like to COUNTA in column B if column A equals "Active".
How would I string together a formula for this?
Thanks,
Victoria
If your column B values are text entries then this should work for you
=COUNTIFS(A:A,"Active",B:B,"*")
otherwise to count any entry in B when A is active (including numbers) you could use SUMPRODUCT like
=SUMPRODUCT((A2:A100="Active)*(B2:B100<>""))
Audere est facere
Thanks, this works: =COUNTIFS(A:A,"Active",B:B,"*")
What does the "*" refer to? How is it used?
In this context "*" is a "wildcard" which denotes any character or any number of characters....so it works to count all column B entries where there is text (and column A is "active").
Wildcards don't work with numeric values, though, e.g. if column B contains a number like 999 that formula won't count it - if that's a possibility then the SUMPRODUCT version would be preferable
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks