Jan 13 2022 06:11 AM
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")
Jan 13 2022 06:25 AM - edited Jan 13 2022 06:27 AM