I feel like this is easy as but I'm nearing a murder spree at this point as I can't figure out how to do it.
I've got values in A1 to A5 where people have rated something 1-5.
In b1 to b5 I have one person who gave a 3, marked as a '1' in b3. Another a person who rated it a 4 (thus a '1' in b4). The others are 0.
What formula would give me the result of 3.5 that I desire?
I need you
please God help