EXCEL: Count values in column based on values in corresponding column

Question

I feel like this should be really easy, but I can't figure out the commands.

I have data in columns C and D which either contains a date or is blank. I have data in column H which contains the name of an employee. I want to calculate the total number of times, for each individual employee, non-blank values occur in C and non-blank values occur in D.

CountIf doesn't quite seem to have the capacity to do this. Any ideas?

Sounds like you need =COUNTIFS(). Can you show the table?

Taosique
– Taosique

2014-02-14 10:06:28 +00:00
Commented Feb 14, 2014 at 10:06 — Taosique
– Taosique, Commented Feb 14, 2014 at 10:06

Taosique · Accepted Answer · 2014-02-14 10:11:48Z

1

In addition to previos answer, if your criteria is for non-blank cells:

=COUNTIFS(H:H,"YourName",C:C,"<>"&"",D:D,"<>"&"")

answered Feb 14, 2014 at 10:11

Taosique

7,9143 gold badges33 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

chris neilsen · Accepted Answer · 2014-02-14 10:07:14Z

0

If you are using Excel 2007 or later, use

=COUNTIFS(H:H,"YourName",C:C,"",D:D,"")

answered Feb 14, 2014 at 10:07

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

Collectives™ on Stack Overflow

EXCEL: Count values in column based on values in corresponding column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related