IFSSUM Formula

Occasional Visitor

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




Maybe with this formula.