formula help

Occasional Visitor

I am attempting to do a formula where I add more than 1 thing from a column, currently the formula is,

=SUMIFS(E:E,D:D,"renewal") I also want anything in column D that says rewrite to be included in the total, how do I do that?

1 Reply

@Jeannette110 

Welcome to your Excel discussion space!

 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

 

Please include the following info to help others answer your question:

 

Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.