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


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.