Change <60 Days to search by month
So I have this formula which searches the past 60 days.
=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60))
I want to change it to search my date range {18b Issues Range DT} and show everything in the month of Jan 2024. How would I change this? Any help would be appreciated!
Best Answer
-
Oh That's easy. Try this...
=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row))
Happy to help...
Answers
-
Oh That's easy. Try this...
=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row))
Happy to help...
