Skip to Content
0

Count Instances with two conditions

May 11, 2017 at 08:10 AM

18

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers