countif adjustment

[heathball]

=IF(ISERROR(AC2),AC2,COUNTIFS($B:$B,$B2,AC:AC,"<"&AC2)+COUNTIFS($B2:$B2,$B2,AC2:AC2,AC2))

Hello, Im struggling to add something to this formula, that means

if a cell is blank (blank result from an 'if' formula) in column AC, the resulting cell is also blank, and not '1' which is the current result.

I know its not that hard, but its got me into a real twist.

Thanks in advance

 

[RoryA]

I'm not really sure why your ISERROR part is there, but to test for a blank cell, you can add:

=IF(ISERROR(AC2),AC2,IF(AC2="","",COUNTIFS($B:$B,$B2,AC:AC,"<"&AC2)+COUNTIFS($B2:$B2,$B2,AC2:AC2,AC2)))

 

[heathball]

thats work perfectly, thanks a lot