CODEWITHSUNDEEP
excelexcel-formula
Gene Myers
Gene Myers

Reputation: 1250

I need a count of the number of rows that have a value in each of two columns

Lets say I have two columns B2:B21 and T2:T21 I need the total number of rows that have a value in both column B and T

If B2 has a value of 15, and T2 is blank, don't count that row If B2 is blank and T2 has a value of 5, don't count that row If B2 is blank and T2 is blank, don't count that row If B2 is 45 and T2 is 50, then count this row (+1)

id this clear?

Upvotes: 0

Views: 1702

Answers (2)

Jerry
Jerry

Reputation: 71538

If you want to count a row if for example, B2 has 0 and T1 has 15 (+1), then use this instead:

=COUNTIFS(B:B,"<>"&"",T:T,"<>"&"")

This also works for cells containing text.

Upvotes: 1

user2140261
user2140261

Reputation: 7993

Next time try Super Users when you do not need programming assistance.

=COUNTIFS(B2:B21,">0",T2:T21,">0")

Upvotes: 1

Related Questions