I'm struggling to get a simple equivalent of - what would be in sql = count all where collumn1 = x and column2-date = year 2021
I am using a SUMIF ands it looks like this:
SUMIF((AND ((0f6969c8d5deefae2f3709fad0ebf452#TaskID;="120730"),(BETWEEN(0f6969c8d5deefae2f3709fad0ebf452#TimeStamp;, "2021-01-24T10:11:28Z", "2021-01-24T10:11:28Z"))), 0f6969c8d5deefae2f3709fad0ebf452#Total treated;) )
I've tried other approaches too - but I can't the right result or stop the dreaded "The formula returned an error." message.
In summary, my mission is to:
Sum column numbers of @Total treated where the @TimeStamp column is the year 2021 and the @TaskID column ="120730"
If anyone could help it would be massively appreciated.
Kind regards, Steve.