Hello all,
I got this excell with this formula;
=SUMPRODUCT(--(TEXT('C:\Users\Rob.Holleman\Desktop\[Registratie review.xlsx]Data Gel'!D$2:D$10000;"mmmm")=A4)*('C:\Users\Rob.Holleman\Desktop\[Registratie review.xlsx]Data Gel'!D$2:D$10000>0))
It counts the dates that are in A4 and display the count of it.
I would like to count now the number of dates that contain an "x" in column G and column H in another excell document.
Anyone knows how i do this?
Bookmarks