•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#Countifs
#conditions
#IFNA
#IFS
#COUNTIF
#SUM
#formula
#Depreciated
#disposal
#salvaged parts
#false