Sum IF question

BrunPierre — Wed, 25 Nov 2020 16:16:04 GMT

Re: Sum IF or conditional sum

BrunPierre — Thu, 27 Jun 2019 17:00:02 GMT

Hello guys!

With the above I'd like to perform a conditional s

For every R_Type , sum the %contribution based on the R_company, that is

IF R_Type = C and R_Company is unique (F0), then 0 + 40 = 40

IF R_Type = F and R_Company is unique (FS and SS), then 0 + 54.17 = 54.17

IF R_Type = T and R_Company is not unique (F5 & SS), then 0 + 22 *(2) = 44 because there are two distinct R_Company.

Thanks

rubenmarin — Thu, 27 Jun 2019 18:45:17 GMT