How to Turn a Sumproduct into a Sumif

HI-

How can I change this formula into a sumif/sumifs?

Please Login or Register  to view this content.

Thanks

Try

=SUMIFS('EZE Comp P&L'!$O$2:$O$9971,'EZE Comp P&L'!$Q$2:$Q$9971,C$8,'EZE Comp P&L'!$B$2:$B$9971,"India")

Thank you. One more question. If I wanted to add names instead of india, would I just do an {"msft,aapl,crm"} ?

Thanks

Try

=SUM(SUMIFS('EZE Comp P&L'!$O$2:$O$9971,'EZE Comp P&L'!$Q$2:$Q$9971,C$8,'EZE Comp P&L'!$B$2:$B$9971,{"msft","aapl","crm"}))