Help needed
 

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

Mike, see if something like this will work =IF(A135,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

"Mike Kasiorek" wrote in message
...
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

Hi
try
=MAX(0,35-SUM_Formula)

--
Regards
Frank Kabel
Frankfurt, Germany

"Mike Kasiorek" schrieb im Newsbeitrag
...
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

Hi

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

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


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Mike Kasiorek" wrote in message
...
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

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

Mike Kasiorek wrote:
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