I currently have this formula that counts data from cells in Column B and C- I need to amend the formula so it won't count if a cell in column D is displaying the word "N/A"
As you can see in the example sheet, "L03" in the table is being counted as "4" however this needs to be zero as the "N/A" is being displayed in column D against code "L03
=COUNTIFS(B:B,"1",C:C,"L01")
The above code is what I have to count everything - I have tried everything and not getting anywhere. Please Help.
Aucun commentaire:
Enregistrer un commentaire