I am trying to get this formula to work

=countifs(J6:J365, "=David & Victor", K6:K365, "=g3")

where G3 is a date value (e.g., 02/24/14).

I am trying to count the instances in my spreadsheet where David & Victor had any activity on that date. It is an on-going sheet so the date changes as the week progresses. The formula works if I write it this way:

=countifs(J6:J365, "=David & Victor", K6:K365, "=02/24/14")

However this means that I have to modify the formula too many times. Can someone help me figure out how else I can do this?


1 Answer 1


Apply the following adjustment to your formula.


=COUNTIFS(J6:J365, "=David & Victor", K6:K365, "="&G3)


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.