I have a spreadsheet where I am wanting to count the number of occurrences where there is number data in Column H but no text data in Columns J and K. So, to recap, I need to count the number of occurrences where there is a phone number in Column H, but only when there are no email addresses in both Columns J and K in the same row. The relevant range in this spreadsheet is H3:K1740. I have tried several different formulas without success. Can someone please help me? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
COUNTIF Based On Two Conditions
- Thread starter bpbenda
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,174
- Office Version
- 365
- Platform
- Windows
Assuming that you have Excel 2007 or newer, you can use COUNTIFS, i.e.
Have a look here for COUNTIF tips, especially the Criteria, as it relates to blanks: https://www.ablebits.com/office-addins-blog/2014/07/02/excel-countif-examples/#countif-blank
Code:
=COUNTIFS(H3:H1740,"<>"&"",J3:J1740,"=" & "",K3:K1740,"="&"")Have a look here for COUNTIF tips, especially the Criteria, as it relates to blanks: https://www.ablebits.com/office-addins-blog/2014/07/02/excel-countif-examples/#countif-blank
Upvote
0
Similar threads
- Solved
- Question
