Hi
I am trying to do a countif on a column in a different tab, where I'm entering my formula, on a spreadsheet I have.
If I use the following formula:
=IF(K21=TODAY(),(SUM(COUNTIFS('5 Actual Dates'!H:H,{"<=23/03/2018","Complete"}))),"")
The count works.
If I change the date above to a cell which contains that date i.e.
=IF(K21=TODAY(),(SUM(COUNTIFS('5 Actual Dates'!H:H,{"<=K21","Complete"}))),"")
It doesn't work. K21 has the date 23/03/2018 entered in it.
Thanks
Solved by F. C. in 26 mins