formula help

[Jeannette110]

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?

[#2]

@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:

• Device and OS platform, e.g., PC/Windows 10 (see Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using)
• Excel product name and version number (see About Office: What version of Office am I using?)
• Excel file you’re working with or sample file with data – please remove all confidential and PII data 
• As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow*
• Expected result and method to achieve the result**

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.