Why is my SUM not working

[publication1]

Hello everyone,

What i'm trying to do it this:-

=Sum(RECOVERED_857) + Sum(RECOVERED_867) / 2100 * 100 -- Unsure why this is not working out correctly its saying 9.3%

RECOVERED_857 = 10
RECOVERED_867 = 25
SO the total is 35

Basically 35 / 2100 * 100 -- I need to replace the 35 with (RECOVERED_857) + (RECOVERED_867)
The correct answer im after is 1.6 but using (RECOVERED_857) + (RECOVERED_867)

[sunny_talwar · Accepted solution]

Try this

=(Sum(RECOVERED_857) + Sum(RECOVERED_867))/2100 * 100

[sunny_talwar]

@publication1 or just this

=(Sum(RECOVERED_857) + Sum(RECOVERED_867))/21

[publication1]

I was trying to wrap sum and nest it like you however it was saying nesting is not allowed, this worked for me so thank you !!