i was cracking my head for a formula (solution) to my problem
I was trying to nest COUNTIFS into IF statement, but before I really cracked my head on how to combined it, I just miraculously hit enter and it showed me this
=COUNTIFS($C$716:$C$3162,C716,$D$716:$D$3162,"Piccolo - Anthracite")*IF(K716="Capsules",E716,"0")
First, I entered =IF(K716="Capsules",E716,"0")
Then, I entered =COUNTIFS($C$716:$C$3162,C716,$D$716:$D$3162,"Piccolo - Anthracite") IF(K716="Capsules",E716,"0") [WITHOUT THE ASTERISK]
Then, I hit enter it auto populates the ASTERISK in between the COUNTIFS and IF statement, and miraculously solved my problem LOL.
Wonder what does that formula mean?
Bookmarks