Bạn đang xem: Using countblank within a countifs function
- Feb 14, 2010
1 __Sam ______Joe
3 __Harry_____ Sue
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