IFSSUM Formula

Copper Contributor

I am trying to create an IFSUM formula for this spreadsheet. The parameters are:

 

Property Classification: D5

State: E5

PFRG Commission: H5

Commission Rate: I4

 

If Property Classificaiton = Residential and State = MO, then the value needs to equal PFRG Commission multiplied by the commission Rate

 

I am stuck here:  ''=SUMIFS(H5*I4,D5,"Residential",E5"MO")

1 Reply

@Monika995 

=SUMPRODUCT(H5*I4*(D5="residential")*(E5="MO"))

 

Maybe with this formula.