Hi Rajeev,
Attached file has been solved as per your requirements.
Get back to me in case of any issues.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, May 5, 2010 at 1:10 AM,
Hi Rajeev,
Sorry for replying late..
Please send the sample file..
Regards,
Andy
On Wed, May 5, 2010 at 1:10 AM, Rajeev Nandan rajeev1...@gmail.com wrote:
Dear Group Member,
Please help me to calculate incentive for each technician. I have
tried to apply countifs but could not succeeded.
Dear Rajeev,
I can assume that you are using version above then Excel 2003 to apply
CountIfs.
Alternatively, you can use Countif with Array functionality or some other
function like Sumproduct.
If possible, share the test file with the Group.
--
Thanks Regards,
DILIP KUMAR PANDEY
Dear Group Member,
Please help me to calculate incentive for each technician. I have
tried to apply countifs but could not succeeded. Please suggest if
there is any other way to calculate incentives else help me to apply
COUNTIFS formula.
Regards,
Rajeev Nandan
--