yogi_Compute Sum Of Entries In Column A Based On MultiColumn Criteria

Google Spreadsheet   Post  #2572

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-08-2019

question by: Zach Finch:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/AyVtRAeGmnA;context-place=mydiscussions
How can I find the value of a cell when two factors are combined?
Sorry for the confusing title.

For work I track fraud and we record indicators that an order is bad in Google Sheets along with the value and other criteria. I've been asked to find the total dollar value for all orders that had a risky IP address combined with another bad sign, such as a brand new email address.

How can I search Google Sheets for only instances in which the "Risky IP" cell is combined with another specific cell like "New Email" in the same row?

Thanks!

Zach