CountIf from another sheet

dharberts

Trying to do a countif from another sheets columns:

=COUNTIF({eCOADept}, CONTAINS("Device", @cell), {AwardD}, >=DATE(Year@row, 12, 1), {AwardD}, <=DATE(Year@row, 12, 31))

Getting back #INCORRECT ARGUMENT SET

Lisa LS Kennedy

You can't have multiple criteria with COUNTIF. You can use use COUNTIFS or COUNT(COLLECT

Lisa Kennedy

Senior Consultant | Smartsheet Development

Prime Consulting Group

Email: info@primeconsulting.com