Hello everyone,
I have an excel file in which I need to find the count of a column.
Column B has ASIN Column C has status.
Column C few cells are marked as "done"
I need to count the number of ASIN where column C is blank.
Sample file is attached for reference.
Someone kindly help me out.
Thank you.
Try
E3Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
This will do that for you:
=COUNTBLANK($C$2:$C$23)
but this is better, as the range does not need to be adjusted all the time...
=COUNTA(B:B)-COUNTA(C:C)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
or try: =COUNTIFS(B2:B23,"*",C2:C23,"")
for full range:
=COUNTIFS(B:B,"*",C:C,"")
Last edited by sandy666; 05-16-2017 at 02:57 AM.
Simple straight forward formula.Originally Posted by shukla.ankur281190
I didn't think out of the box.
Thank you Ankur.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks