SOLVED

# Excel sharepoint formula

Copper Contributor

# Excel sharepoint formula

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.

3 Replies

# Re: Excel sharepoint formula

We cannot access your file I'm afraid.

# Re: Excel sharepoint formula

best response confirmed by krishnarambaccus (Copper Contributor)
Solution

# Re: Excel sharepoint formula

You can use the SUMIF() function for this task:

``=1-SUMIF('Raw Data'!C\$2:C\$17,A2,'Raw Data'!D\$2:D\$17)``

1 best response

Accepted Solutions
best response confirmed by krishnarambaccus (Copper Contributor)
Solution

# Re: Excel sharepoint formula

You can use the SUMIF() function for this task:

``=1-SUMIF('Raw Data'!C\$2:C\$17,A2,'Raw Data'!D\$2:D\$17)``