Counting a column with multiple selection and Dates per month

William Evans

Hello,

I am trying to reference another sheet to count the number of times the following "Other, NA, and Blanks has been entered per month "Example for July, August, etc". Any help would be greatly appreciated.

GPO.jpg

Dates.jpg

"Example Other, NA, and Blanks"

Jeff Reisman

@William Evans try this for the month of July:

=COUNTIFS({Other Sheet Assigned Date Range}, MONTH(@cell) = 7, {Other Sheet GPO Range}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell)))

William Evans

Jeff, I used the following formula =COUNTIFS({Date Received}, MONTH(@cell) = 7, {GPO}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell))) and I am getting "Invalid Data Type

Jeff Reisman

@William Evans try this for the month of July:

=COUNTIFS({Other Sheet Assigned Date Range}, MONTH(@cell) = 7, {Other Sheet GPO Range}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell)))

William Evans

Jeff, I used the following formula =COUNTIFS({Date Received}, MONTH(@cell) = 7, {GPO}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell))) and I am getting "Invalid Data Type

William Evans

Jeff thanks it works now!