Hi,
I discovered in a report at work that a formula was not working, after much tinkering with it and a lot of trial-by-error myself I thought I had fixed it yesterday via
{=COUNT(IF(FREQUENCY(IF((BU="Team 1"),IF((Month=B1),IF((RTW_Evi=""),IF((PayType="PAYE"),CanID)))),CanID),1))}
This did pull through results, so the fact that today it doesn't leads me to believe I rushed off too soon and might have witnessed some odd kind of artefacting on the screen whilst the formulas got to 'working' and the sheet was processing.
The intention of the formula is to look at the named fields and match the criteria therein, and bring me back a count of those contractors who are in Team 1, the month matches, the Pay type is PAYE, they are missing any RTW Evidence, and to stop double-counting of the same individual check it against the CanID number.
Can you help me? Example file attached.
I know I am likely being dense and have misordered the parenthesis or a comma at some point
Bookmarks