Solved

Microsoft Excel 2007 formula

Posted on 2012-04-13
2
392 Views
Last Modified: 2012-04-16
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.
0
Comment
Question by:mmcgillo88
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 250 total points
ID: 37844942
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
 
LVL 42

Accepted Solution

by:
dlmille earned 250 total points
ID: 37845423
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question