1 min readfrom 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.

submitted by /u/Ok_Vacation_7897
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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