Forum Discussion
bea87
Jan 25, 2023Copper Contributor
Excel multiple actions
Hi All
I'm struggling a little with writing a formula that has multiple actions. It's a budget spreadsheet and I want the column to add together the cells that have a "Y" in them so the formula will be =IF(D3:D11="Y")THEN=SUM so it adds only the cells that have a Y in them.
2 Replies
- Riny_van_EekelenPlatinum Contributor
- bea87Copper ContributorThank you! Think I was confusing myself and not realising the commas!