Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 273
Default sumproduct

I have a system to reward sales people with 1 point each time they make 5
phone calls in a day. If they make 10 phone calls they get 2 points. If they
made 9 calls, it's only 1 point. I have a cell for each day of the week in a
row for a particular salesperson. I enter the number of calls that person
makes each day and want to know how many points to award a person based upon
how many phone calls are made in groups of 5 each day. 1 call 0 points, 5
calls 1 point, 12 calls 2 points, 15 calls 3 points, 16 calls 3 points, 25
calls 5 points, etc.

I need to count the number of times cells in a row contain a number = to 5
and if greater than 5, I need to count how many times 5 is divisible into the
number of calls made each day. I tried =COUNTIF(I10:GC10,"4"), but this only
tells me the number of time the sales person made at least 5 calls in a day
and does not account for more than 5 calls in a day.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional SUMPRODUCT or SUMPRODUCT with Filters Ted M H Excel Worksheet Functions 4 August 14th 08 07:50 PM
sumproduct? sumif(sumproduct)? David Excel Worksheet Functions 3 July 13th 07 07:06 PM
Sumproduct Curtis Excel Worksheet Functions 1 March 5th 07 11:42 PM
Help with SUMPRODUCT FrankTimJr Excel Discussion (Misc queries) 4 October 12th 05 04:27 PM
Sumproduct..help please Terry Excel Worksheet Functions 6 September 30th 05 08:53 AM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"