Help needed

[Mike Kasiorek]

Hello there, I need some help figuring out the correct formula...What I
am doing is adding the number of parts done by a particular person and
when this total reaches 35, I would like to show in another column, how
many over 35 he/she has done as a incentive will be paid on this number
over 35..I was able to get the simple part - the adding up to 35 done
but have gotten no further.....any help will be greatly appreciated.....Mike

 

[Paul B]

Mike, see if something like this will work =IF(A1>35,A1-35,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Frank Kabel]

Hi
try
=MAX(0,35-SUM_Formula)

 

[Arvi Laanemets]

Hi

Alhough you have first formula, here is my example for this too:
Amount1=MIN(35,SUMIF(ConditionRange,Condition,SumRange))

The formula you asked for:
Amount2=SUMIF(ConditionRange,Condition,SumRange)-Amount1
(Instead Amount1 insert the reference to cell with first forlmula)

 

[Mike Kasiorek]

Thanks you all, finally got it figured out and looks good....