=SUMPRODUCT(--($J$1:$J$380=$K393),--($O$1:$O$380<>""))
That is my formula is there a way for this formula to omit the #N/A? I have an "X" in the cells that i need counted but because of the #N/A it return the #N/A instead of the total of the X's
Sorry if this is confusing
Bookmarks