Forum Discussion
Solved
Excel sharepoint formula
https://docs.google.com/spreadsheets/d/1utdQMucH7XDKTmJHIjLITOgeQHazQXibZktqMxSAA9g/edit?usp=sharing
Hi, I need assistance with the "Bandwidth" tab, specifically cells B2
. In the "Raw Data" tab, if an employee's name appears in column C, the formula for B2 should be 1 minus the sum of values in column D for that employee. For example, if Jeff has values 0.20 and 0.45 in the "Raw Data" tab, then in the "Bandwidth" tab, B2 should be calculated as 1 minus 0.20 plus 0.45.
You can use the SUMIF() function for this task:
=1-SUMIF('Raw Data'!C$2:C$17,A2,'Raw Data'!D$2:D$17)
3 Replies
- We cannot access your file I'm afraid.
I have updated the link, my apologies. https://docs.google.com/spreadsheets/d/1utdQMucH7XDKTmJHIjLITOgeQHazQXibZktqMxSAA9g/edit?usp=sharing
Thank youYou can use the SUMIF() function for this task:
=1-SUMIF('Raw Data'!C$2:C$17,A2,'Raw Data'!D$2:D$17)
