Forum Discussion
elFarmer2120
Sep 13, 2023Copper Contributor
SUMIF function with different columns
Hi, I'm trying to create a SUMIF function to add the sum of columns and I ONLY if column F = "deposit funds." I've tried =SUMIF(F3,"deposit funds",H3+I2), but it wont' work. I also tried SUMIFS with the same function, but that also didn't work. I want the sum to change over time, so I can see the total amount of funds we've added to an account on a specific date (ex., on 8/24 $2000 was added, on 8/30 $500, on 9/2 $1000, etc., for a total of $2000 on 8/24, $2500 on 8/30, $3500 on 9/2, etc.). If column F does NOT = "deposit funds," I would like column I to repeat the same total as the above row (ex., 8/24, 8/25, 8/26, 8/27, 8/28, and 8/29 would all display $2000, until 8/30 when $500 is added). I hope this makes sense. Thank you!
2 Replies
- OliverScheurichGold Contributor
- elFarmer2120Copper ContributorOmg yes! THANK YOU!