Hi Have this formula in spread sheet and need a little help.
=COUNTIFS('Overdue Actions'!B5:B1048576,"Craig", 'Overdue Actions'!O5:O1048576,"Overdue",'Overdue Actions'!P5:P1048576,">=183",'Overdue Actions'!P5:P1048576,"<365")
I need this to show the 0 value as blank cell, I have tried suggestion on the IF at the start etc and worked, but it also blanked cells that met the criteria. ie. blanked cells for 0 results, but also blanked cells that had 12 in etc.
Any help, appreciated.
Thanks
Mark
Bookmarks