Countifs contains

dharberts

Trying to count if a cell by criteria if another cell contains "device":

=COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31))

#INVALID OPERATION

Adam Murphy

Try this: =COUNTIFS([eCOA Department]:[eCOA Department], CONTAINS("Device", @cell), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) This assumes Year# being replaced with an actual year.

Leibel S

@dharberts

Try the below:

=COUNTIFS([eCOA Department]:[eCOA Department],CONTAINS("Device",@cell), [Award Date]:[Award Date], @cell>=DATE(Year#, 3, 1), [Award Date]:[Award Date], @cell<=DATE(Year#, 3, 31))

Adam Murphy

Try this: =COUNTIFS([eCOA Department]:[eCOA Department], CONTAINS("Device", @cell), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) This assumes Year# being replaced with an actual year.

Leibel S

@dharberts

Try the below:

=COUNTIFS([eCOA Department]:[eCOA Department],CONTAINS("Device",@cell), [Award Date]:[Award Date], @cell>=DATE(Year#, 3, 1), [Award Date]:[Award Date], @cell<=DATE(Year#, 3, 31))

dharberts

That worked thank you