SOLVED

how to total column with IF or some other function?

Copper Contributor

I'm a mediocre excel user, not an expert! I pretty much only use the Sum function. This time I need to total column G for the cells in column B that equal "Tithes and Offerings." How do I write that formula? My sheet attached. 

BeckyBo334_0-1686254376767.png

 

3 Replies
best response confirmed by BeckyBo334 (Copper Contributor)
Solution

@BeckyBo334 

Perhaps this:

=SUMIF($B$2:$B$6,"Tithes*",$G$2:$G$6)

Oh my goodness. You are my hero! Thank you so much! It worked perfectly!

 

You're welcome!
1 best response

Accepted Solutions
best response confirmed by BeckyBo334 (Copper Contributor)
Solution

@BeckyBo334 

Perhaps this:

=SUMIF($B$2:$B$6,"Tithes*",$G$2:$G$6)

View solution in original post