=COUNTIFS($H$2:$H$9999,"",$A$2:$A$9999,BN61)
I have above formula in 1 cell, where it counts rows where BN61 is present in A, and H column is blank
Above formula is working fine, but now I want to sum it.
Means sum the figure present in L where BN61 is present in A and H column is blank. How can I do this ?
Bookmarks