Good Day All
Im trying to count the amount of times a specific value appears in a different sheet on the same workbook
These must be separated by month (a column in the data sheet contains the date)
Ive been trying:
=COUNT(QUERY(scandata, "select D where D<'6/01/2018' & D>'4/30/2018' ))"))
seems to return a zero value when I know for a fact there are at least 4x in that month.
Thank you very much for reading!
Bookmarks