Skip to Content

Count Instances with two conditions

Hi,

I have a report where I need to do a count of instances by day and by user, I can do the formula in excel:

COUNTIFS([DATE_RANGE],[@[DATE], [USER_RANGE],[@[USER],[TARGET_RANGE],[@[TARGET])

Where [TARGET] is the item to be counted, example attached

This is what I done so far in a variable, but when I add [Date] returns #ERROR COUNT([TARGET]) IN ([USER]) returns the number of unique TARGET in all the rows COUNT([TARGET]) IN ([USER];[DATE]) returns #ERROR

as an Add On when I check the filed type for [DATE] seems to be a string as; IsString([DATE]) = 1

and all the others (IsDate; IsNumber; IsLogical; IsTime) = 0

so I am a bit confused... :?

Any help and all the help is very much appreciated,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers