Microsoft Excel 2007 formula

I need a count if formula where in Column A I have a name and Column B I have a value. I need a formula so that if A = a certain name it will return a 1 (just a simple count function) and if it doesn't have a value in Column B then it will return a 0.
mmcgillo88Asked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
I think I would modify that so that for column B to return a 1 if the name is found and there are more than one occurrences of that name having a value that's not blank, and 0 if there are no matches of that kind, you would need:

=IF(COUNTIFS(A:A,D2,B:B,"<>")>0,1,0)

Dave
0
 
barry houdiniConnect With a Mentor Commented:
Do you want to do that for the whole column? This will count rows that have your designated name in column A and where the corresponding row in column B is not blank

=COUNTIFS(A:A,D2,B:B,"<>")

where your name to count is in D2

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.