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...
You can use the SUMIF() function for this task:
=1-SUMIF('Raw Data'!C$2:C$17,A2,'Raw Data'!D$2:D$17)
I have updated the link, my apologies. https://docs.google.com/spreadsheets/d/1utdQMucH7XDKTmJHIjLITOgeQHazQXibZktqMxSAA9g/edit?usp=sharing
Thank you
You can use the SUMIF() function for this task:
=1-SUMIF('Raw Data'!C$2:C$17,A2,'Raw Data'!D$2:D$17)