Google-sheets – Using cell reference with COUNTIFS formula

google sheets

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?

Best Answer

Apply the following adjustment to your formula.

Formula

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

Screenshot

enter image description here

Related Solutions

Google Sheets – Complex Formula

In Dashboard D36 please enter:

=sumif(log!C:C,A36,log!B:B)

(should result in the 19 you mentioned) and then copy up to D4.

Google Sheets Variables – Save Temporary Variables in Formulas

I often end up using cells as variables for often used computations, and in fact name them using "named ranges". It makes it easier to think about the formula you are trying to develop. You can hide those cells, if you do not want them to be seen.