Hello, I’ve just recently started using spreadsheets to help manage my budget and sometimes I have a time when the amount isn’t actually used, is there a way to check if a cell has a certain value to then use the number from another to add it to the calculation.
=SUM(B2,B3,B4,B5,B6) gives me the total for all of these but B4 and B6 aren’t always used, so what i’m trying to accomplish is: if C2=”YES”, C3=”YES”, C4=”NO”, C5=”YES”, C6=”No”
then =SUM(B2,B3,B5)
does that make sense to anyone? lol
