Hello Everyone
i dont know what "<>"& "="& means in the following formula as a criteria
i know = and <> , but i dont know what does & means in this place, also i dont know whats the quotatios do ""
=IF(ISBLANK(U3447),"",COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,"<>"&D3447))+IF(ISBLANK(U3447),"",COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,"="&D3447))
Bookmarks