Kiến thức

Using countblank within a countifs function

L

Bạn đang xem: Using countblank within a countifs function

lisabandit

Thread Starter

Joined
Feb 14, 2010
Messages
2

Feb 14, 2010

  • #1

I have two columns with data (A & B). I want to use countifs to count a certain condition that occurs in column A and see if that conditoin corresponds to a blank in that row for column B. For example

_____A_________B

1 __Sam ______Joe

2 __Sam__________

3 __Harry_____ Sue

4__ Harry_________

5 __Harry_____ Pete

I would like to get a count for each occurence where both Harry occurs in column A and when there is a blank in column B (across the rows). I tried =countifs(A1:A5,”=harry”, B1:B5,”=countblank”) hoping to get the answer 1 (Where Harry + a blank cell are in only one row (4)) with no success.

I know if I want to count when both Harry occurs in A and Sue occurs in B it’s =countifs(A1:A5,”=Harry”, B1:B5,”=Sue”) and I get the answer 1 (where Harry + Sue occur in one row (3)). But I can’t seem to apply the same logic with countblank in the countifs function. Please help Thanks.

PS. The real data set is about 500 columns, this is just an example.

 

Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Close
Back to top button