lundi 3 octobre 2016

If Column D is Direct, Sumproduct(E,F)

I have a worksheet set up like what is below, can someone tell me how to sumproduct columns E and F when column D = "Direct"?

Column D  Column E  Column F
Direct     $500       1
Indirect   $250       3
Direct     $100       4
Indirect   $600       8
Indirect   $1100      2

Answers should be Direct = $900

Aucun commentaire:

Enregistrer un commentaire