COUNTIFS FORMULA

Ed Gadd

Can anyone help where the error to this formula is please?

Just trying to count if a date appears in one column and a color appears in another. Should be easy right?

=COUNTIFS(({Range DATE CREATED}, DATE@row),{Range Colour}, "RED")

Monique Odom-Stearn

Hello @Ed Gadd,

It looks like you have an extra parentheses around the first criteria set. Try this:

=COUNTIFS({Range DATE CREATED}, DATE@row, {Range Colour}, "RED")

Monique Odom-Stearn

Hello @Ed Gadd,

It looks like you have an extra parentheses around the first criteria set. Try this:

=COUNTIFS({Range DATE CREATED}, DATE@row, {Range Colour}, "RED")

Ed Gadd

Works perfectly, thank you so much.