•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Countifs with mutiple conditions
hello!
if anyone can help will much appreciated been stuck for one week for this.
this my formula.
IFNA(IFS(COUNTIF(G2,"\*DONE\*"),"logged in the system",
SUM(COUNTIFS(K2,{"\*Depreciated\*","\*Depreciated\*"})),"For disposal/salvaged parts",
sum(countifs(c2,{"\*false\*","\*false\*"})),"Get info in the engr. dept"),"For checking")
I know there is mistake in my formula. i just can't correct it yet.
I can't trigger some of the returned conditions.
Edit: should be column in the picture should be results. Thank you for any being kind helping me.
[link] [comments]
Want to read more?
Check out the full article on the original site