1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I think i need guidance for this gantt chart

https://preview.redd.it/6ai2sx03k6tg1.png?width=1887&format=png&auto=webp&s=119bb1f875aaec4f043bc7d38d7aca6914cfaf3d

Can anybody help me put a formula to sum only those that are in dark green color when i vertically sum all amounts using auto sum? (the green color has a formula, if they reached a certain progress it will prompt the criteria "TRUE". The formula is in conditional formatting.)

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#formula generator
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis