Help with formula

[Richard]

I'm using this formula.
=IF(C2="","",SUMIF('Part Number'!A:A,A2,'Part Number'!B:B))
I need the results from this formula to show me a % of that number.
Example: Whatever number shows up in this formula is 100%. divide that
number by the number in cell c2 to give the actual percentage rate. I've
tried adding a /c2 sign at the end if this but I'm not getting an actual
percentage. The cell is already formatted as a percentage. Thanks in
advance!!!

 

[Mike H]

If I understand correctly, try this

=IF(C2="","",(SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)/C2))

Mike

 

[Richard]

I've tried that but for some reason it doesn't work returning the correct
percentage. Example if the results in c2 and the results in d2 are the same
it does return the correct percentage such as C2 = 24 and D2 = 24 it will
return 100% but if the results in C2 = 12 and the results in D2 = 24 it
returns 200% but it should return 50% Thanks for your help!!!

 

[Mike H]

Hi,

That's what I would expect but if you want it the other way around do it
like this

=IF(C2="","",(C2/SUMIF('Part Number'!A:A,A2,'Part Number'!B:B)))

Mike

 

[JLatham]

Turn your division around. 24 truly is 200% of 12. That is, if C2=12 and
D2=24 and you do =D2/C2, the answer is 2 which is 200%. But if you did C2/D2
you'd get .5 or 50%.
Sounds like the formula may need to be written as
=IF(C2="","",C2/SUMIF('Part Number'!A:A,A2,'Part Number'!B:B))
You may need to make sure that the SUMIF() doesn't evaluate to zero to keep
#DIV/0! errors from popping up.