Forum Discussion
Solved
COUNTIFS with date range within a cell
Hello, I am trying to build a template for use every month, where the date range would change for each month to the month in question. The same countifs formula would be used in multiple cells wi...
=COUNTIFS(Sheet1!D:D, ">"&A1,Sheet1!D:D, "<"&A2)
=SUMPRODUCT((Sheet1!D:D>A1)*(Sheet1!D:D<A2))
These formula return the intended result in my sheet.
=COUNTIFS(Sheet1!D:D, ">"&A1,Sheet1!D:D, "<"&A2)
=SUMPRODUCT((Sheet1!D:D>A1)*(Sheet1!D:D<A2))
These formula return the intended result in my sheet.
amazing !! thank you the first one worked with the &
Thanks 🙂
Thanks 🙂