Forum Discussion

bea87's avatar
bea87
Copper Contributor
Jan 25, 2023

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