Comments on: How to use VLOOKUP with SUM or SUMIF functions in Excel

In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Continue reading →

Comments page 11. Total comments: 441

  1. I have a table of 3 columns: Course, Credit and Category:
    Course Credits Category
    10 3 GE
    20 3 GE
    22 3 GE
    40 3 GE
    56 3 Surveys
    71 3 Lower Division CW

    I have another worksheet where I am entering the courses per instructor and totaling the units

    so for Fall 15 semester teacher teaches 3 courses and it totals the units
    Cindy 22 40 56 9 units
    Bill 71 56 40 9 units

    I used a vlookup to calculate the units based on which course was entered and total it by semester by instructor. That works fine.

    I want to now total the categories for each semester

    Categories
    GE
    Surveys
    Lower Division

    It should look up the category associated with the course (Above table course 10 is a GE Category) and count the instances where it finds a course that falls into the GE Category.

    GE 15 courses
    Surveys 10 courses
    Lower Division 9 courses

    Any help you can give me will greatly appreciated

  2. Dear i have following example data of 3 different clients. Now if i want to sum "Apple", "Orange" etc. then what kind of formula should be use. plz guide.
    Ahmed & CO =
    APPLE 5 2 3 4
    ORANGE 4 1 2 3
    LEMON 3 4 5 5
    COCONUT 2 1 3 4
    Sharif & CO =
    ORANGE 4 2 4 2
    APPLE 6 4 4 5
    COCONUT 3 7 4 6
    Sharif & CO =
    COCONUT 2 4 3 2
    ORANGE 4 3 4 2
    APPLE 5 3 2 4

  3. Sl No. ItemID Program Category Efforts
    1 P001 Interior Design 120
    2 P002 Exterior Drawing 40
    3 P003 CAE annotation 33
    4 P004 Seating Packaging 456
    5 P005 Interior Design 22
    6 P006 Interior Drawing 55
    7 P007 Exterior annotation 6677
    8 P008 Exterior Packaging 244
    9 P009 Exterior annotation 786
    10 P010 CAE Packaging 44
    11 P011 CAE Design 245
    12 P012 Seating Packaging 9887
    13 P013 Exterior Design 54
    14 P014 Exterior Drawing 444

    Hi Svetlana,

    Please help me to get a formula to get the total efforts when program and category in different rows same.
    Exampple : from above data
    Sl No. 4 & 12 have same program and category, so their sum is 10343.

  4. Hi

    I have an expense report that runs chronologically for an entire year. I would like to have a formula that can sum the amounts by month and by item. I.e. Sum all amounts in column X (highlight entire range) that say January in column Y and "Elect. bill" in column Z. Is this even possible?

  5. I have 50000 entries in excel sheet and i have to do page wise totals. Needs to print on dot matrix printer later on. I also need page wise summary of totals.
    there are entries like voucher No.s having different transactions. I want to club the total amount against the one voucher No. instead of repeating it. it will save paper. Please help

    Thanks

  6. Very good site , very educative

  7. I have a situation similar to the first example on this page, i.e. fruits in multiple rows and months as columns. The formula is great for finding one fruit and adding multiple columns in the array. However, I have the same fruit listed in multiple rows. I need to add the months amounts for each row that the fruit is listed. Is there a way I can do this in a formula without creating a pivot table?
    Thanks

  8. I need a formula to update a sales sheet. as i have multiple of contract numbers in one column and each contract has some value that i want to sum. with pivot table it be done however i need a formula. can please advice...

    Contract # Status Car Plate # Pymt_Customer
    577 Open 7823 1500
    586 Open 7827 0
    586 Closed 7827 165
    584 Open 7822 1500
    584 Closed 7822 -1020
    577 Closed 7823 -265

  9. i need to add values corresponding to (say) 4th coloumn if values or data in 1st 2nd and 3rd coloumn match.

    division name date expense
    sales a 20-Jul-15 1
    pdtn b 5-Jul-15 2
    sales c 10-Jul-15 3
    pdtn d 20-Jul-15 4
    sales a 5-Jul-15 5
    sales a 10-Jul-15 6
    sales a 20-Jul-15 7
    sales c 10-Jul-15 8
    sales c 5-Jul-15 9
    pdtn d 20-Jul-15 10

    if data of A , B AND C coloumn match then it should do sum total of values in D
    for any new unique combination of A,B and C coloumn a new row automatically should be created

    I want the result to be like this

    sales a 20-Jul-15 8 (1+7)
    pdtn b 5-Jul-15 2
    sales c 10-Jul-15 11 (3+8)
    pdtn d 20-Jul-15 14 (10+4)
    sales a 5-Jul 5
    sales a 10-Jul 6
    sales c 5-Jul-15 9

    can someone help me on this. thanks in advance

  10. Hi, Svetlana. I read your article on SUM and VLOOKUP and I practiced some examples about the combination of SUM and VLOOKUP/ INDEX. And I have some questions relating to the first example in above article.

    I want to extract the apples' sales figures for 3 months (Jan, Feb, Mar) separately in 3 cells. I choose 3 cells and enter the same array formula:

    {=VLOOKUP("apples",'Monthly sales'!$A$2:$M$9, MATCH({"Jan","Feb","Mar"},'Monthly sales'!$A$1:$M$1,0))}

    Result of above formula is 3 cells contain sales figures of 3 months.
    And I use INDEX formula and receive the same results:

    {=INDEX('Monthly sales'!$A$2:$M$9, MATCH("apples",'Monthly sales'! $A$2:$A$9,0),MATCH({"Jan","Feb","Mar"},'Monthly sales'!$A$1:$M$1,0))}

    My PROBLEM is:
    1- When I use the combination VLOOKUP with SUM and received a correct result as the following:
    {=SUM(VLOOKUP("apples",'Monthly sales'!$A$2:$M$9, MATCH({"Jan","Feb","Mar"},'Monthly sales'!$A$1:$M$1,0)))} =$26,189

    2- But when I try to combine SUM with INDEX in a similar way, I only receive the apples'sales of Jan:

    {=SUM(INDEX('Monthly sales'!$A$2:$M$9, MATCH("apples",'Monthly sales'! $A$2:$A$9,0),MATCH({"Jan","Feb","Mar"},'Monthly sales'!$A$1:$M$1,0)))} =$2,773

    - However, when I calculate the apples' sales for all 12 months by using SUM and INDEX (with col_num =0), I receive the correct result.

    {=SUM(INDEX('Monthly sales'!$A$2:$M$9, MATCH("apples",'Monthly sales'! $A$2:$A$9,0),0))} =$172,008

    Could you please explain for me why the second formula not return the correct result?
    I looking forward to receiving your reply. Thank you.

  11. Hi Svetlana,

    Need your expertise again!!! I am suppose to make performance meter but can't get the desired results. Please have a look;

    Year Month Name leads Matured Conversion%
    2015 June Anju 30 2 7%
    2015 June Rekha 28 2 7%
    2015 June Somya 35 2 6%
    2015 July Anju 40 4 10%
    2015 July Rekha 35 5 14%
    2015 July Somya 45 5 11%

    How to get the average of Conversion% based upon extracting data from below selection:
    Select [From Month/Year---> to Month/Year] eg; [2015/June--->2015/July]
    Select Name eg; Anju
    Result should show Average% of selected Name based upon year and month range selected.

    I have been trying vlookup, index & match, sumif but didn't get through.

  12. PURCHASE
    SL.No GRADE FINISH THIKNESS WIDTH HEIGHT GRAVITY NO COIL QTY
    1 304 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    2 316 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    3 321 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    4 309 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    5 LN-1 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    6 LN-4 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    7 200-S 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    8 SA 15.84 0.6 1500 2200 0.000008 1 Yes 15.84
    9 430 15.84 0.6 1500 2200 0.000008 1 Yes 15.84

    I need the vlookup formula for the above.

    you can see in the second coloumn "GRADE" that is the order may apper many times and need to add the vales of grade. Value is in 'QTY' column. pls let me know how I can do the look up formula.

  13. Hi All,

    I have two worksheets.

    One listing all days against a individual contract e.g.

    Contracts Days
    1234 1
    1234 4
    1234 2
    1234 9
    1235 1
    1235 6
    1235 0
    1235 11
    1236 7
    1236 2
    1236 20
    1237 1
    1237 7
    1237 5
    1237 5

    and the other where I want to look this days total up for that contract e.g.

    Contract Total days
    1234 16
    1235 18
    1236 29
    1237 18

    What VLOOKUP & SUM formula would I use as column one would not work as it is SUMing rows.

    1. Maybe,you can try using SUMIF function.

      Supposing that in Sheet1 the column Contract_number is A2:A16 and column Days is B2:B16 ; in Sheet2 column Contract is A2:A5
      In Sheet2 choose ALL cells B2:B5 and enter a same array formula in Formula bar:
      =SUMIF('Sheet1'!A2:A16,=A2:A5,'Sheet2'!B2:B16)

      Due to it is an array formula and should be ended by Ctrl+Shift+Enter

  14. hi,

    I want to add the individual values of each week for all the months in a year for a list of items.
    I need these to be calculated automatically in a different sheet. Could you help me out with this.
    For example, the main sheet looks something like the below table:
    5Jan - 9Jan 12Jan - 16 Jan etc
    Opening count 1 2
    New 5 7
    Closed 4 6
    Backlog 2 3

    In sheet2:

    I need the following result:
    Jan
    Opening Count 1
    New 12
    closed 10
    Backlog 3

    This needs to be done for all 12 months.

  15. Hello,

    I am working on an extensive spreadsheet with thousands of loan numbers, names, document types, ID numbers, etc. My issue is that each week, this company will send me a spreadsheet of thousands of loans but could very well be duplicates of the previous week. I cannot simply use the function "remove duplicates" because the loans are always duplicated with each separate document request and if I have one loan repeated 3x because it requires 3 different document types, that function will remove 2 of them and throws everything off. How can I weed out the prior week's loan numbers and simply identify what loans are new to the current weeks' spreadsheet? Sorry to be so longwinded. :-)

  16. Hi,
    I have a budget sheet where there is certain budget is allocated in different months under a certain budget heading. And I have a reporting month cell where I have a dropdown box including the names of the month. Now, what I want is to get the result of the sum of the budget of the activity when i respectively change the month. I also want to get the value, if I click the month to march, then i need the cumulative budget value added till march.

    Please help

  17. I have a combination of value such as '1/3 in A1, '3/3 in A2 and '3/6 in A3. Is there a way to sum the that are 1+3+3 so that in the cell I would have 7 and the next cell 3+3+6 that would equal to 12? Basically, I need to sum the 1st values of the A1, A2 and A3 and in the other cell 2nd values of the same cells?

  18. Greetings, I am trying to build a workbook that has 3 sheets. One for entry of first last name and ID number as well as a monetary value like a tip. On the second sheet is the summary page where i wanted the table to return the sum of all information by employee id to give me a total of tips for that employee. The third page i had set up as the reference table where i would enter the First last name and ID number. I tried using your example but still cant get it to work.

    I have pasted the formula below.

    Can you help?

    Im also using google documents

    ={=SUM(Tips!$c$2:$c$30*IF(Tips!$C$2:$C$30=TRANSPOSE(Employee!$c$2:$c$30),TRANSPOSE(Employee!$c$2:$c16),0)*($C$2:$C$2=$I$1))}

  19. hi,
    i have a table in my excel file having different Items date wise, eg:-
    Date No. Name Item quantity
    1/4/15 106 Ab Apple 50
    1/4/15 129 Bd Mango 75
    1/4/15 235 Jp Mango 39
    2/4/15 114 Tk Mango 63
    2/4/15 228 Kl Orange 24
    3/4/15 0 0 0 0
    4/4/15 0 0 0 0
    5/4/15 235 Jp Mango 52
    5/4/15 106 Ab Orange 28
    ...
    .
    .
    .
    .
    and so on date wise, actually i want to monthly date wise quantity in one cell.
    which formula i have to use if i need the quantity of Mango for selected date?
    eg. if i put a date 1/4/15 and match with item Mango, so that in a one cell the total quantity should be 114.

  20. Hi Svetlana!
    I have a column of numbers from which I want the top 10% of the sum of the column to be highlighted. I tried the conditional formatting option. But it doesn't give me a result which is even near 10%.

  21. Hi Mei, we have the same problem! I hope somebody can help!

  22. hi.. im having trouble with my excel..
    you see..my proble is like this
    qty.-------u/m-------product
    2 ------rolls------ thermal paper
    5 ------packs------ pandan jelly
    4 ------rolls ----- thermal paper

    i want to have a summary like this
    thermal paper----- 6
    pandan jelly -----5

    1. Hi Mei,

      Supposing that Qty. is column A and Product is column C, you can use the following SUMIF formula:

      =SUMIF(C2:C100, "thermal paper", A2:A100)

      1. thanks!! that helps a lot!!
        but there is another one.
        example:
        qty----u/m----product------amount
        2-----packs---12 oz lid----
        5-----rolls---thermal paper---
        1-----box-----12 oz lid---

        what i want is somehow, when i type the qty, u/m and product, it will give like...
        thermal paper---6----$
        12oz lid (pack)----2-----$
        12oz lid (box)-----1-----$
        there should be a difference in the price of the per box and per packs... thanks

  23. THANK YOU FOR YOUR WONDER FULL POST. I CAN'T REALLY GET IT RIGHT!!!
    BSERVATION
    FOR FIND SAME MATCH =VLOOKUP(A:A,A:B,2,FALSE) (MIDLE A:B SHEET TO SHEET UR O)
    FOR SUM OF MATCH =SUMIF(A:A,A,B:B) (MIDLE "A" IS OBSERVATION TO FIND)

    THIS IS SUM OF ALLLL YOUR POST. YOU CAN MAIL ME IF DOUBT.

    1. ADD SUMIF CRITERIA (MIDDLE AREA) BY SELECT THE CELL YOU WANTED TO SUM.

  24. Thanks Svetlana! Another question, We got the below formula to work, Thanks for the Ctrl+Shift Enter tip.

    {=SUM(VLOOKUP("Green",$I$26:$L$28, {2,3,4}, FALSE))}

    Jan Feb March
    Green 10 40 70
    Purple 20 50 80
    Yellow 30 60 90

    120

    However, we could not get the same formula to work for the below table. Help please.

    Jan Feb March
    Green 10 40 70
    Green 20 50 80
    Yellow 30 60 90

    120

    1. Hi Vladamir,

      Both tables seem to be identical. Can you check please?

  25. Hi Svetlana, I copied your formula and my sample data is below. I used the formula, =SUM(VLOOKUP("Aaron",$I$26:$J$28,2,FALSE)) I was expecting 50, but got 30. Help please.

    Aaron 30
    Aaron 20
    Jack 10

    30

    1. Hi Vladamir,

      Since you are working with a single table, you don't need SUM/VLOOKUP. A simpler SUMIF formula works just fine:
      =SUMIF($I$26:$J$28, "aaron", $J$26:$J$28)

      1. Hi,
        Is there any possible way to sum data without mentioning "aaron"

        I mean automatically it will sum if the Column A duplicated

  26. Hi Vivien,

    You can use the following formula:

    =SUMIF($A$2:$A$6, $F2, B$2:B$6)

    Where A is the currency column in your main table, B is data for 01-Jan, and F is the currency colum in your summary table.

  27. Hi,

    I have a huge set of data looks like this:
    A B C
    1 CCY 01-Jan 02-Jan
    2 EUR 1000 500
    3 EUR 150 50000
    4 USD 2000 480
    5 JPY 340000 348212
    6 USD 3000 23934

    How can I sum data into below format without using pivot table?

    01-Jan 02-Jan
    EUR
    USD
    JPY

    Thanks.

    Vivien

  28. I have a column of 16 cells with a list of upgrades depending upon the unit style. I have a table with the 3 different upgrades levels and the corresponding price. I would like to SUM the total amount of the upgrades in one cell. I thought it should be a sum with vlookup but it's not returning a value. Any suggestions?

    When I use this formula it only returns the value from the first cell. It doesn't give me the total from the other cells in the lookup value selection.

    {=SUM(VLOOKUP(C40:C55,$A$34:$B$36,2,FALSE))}

  29. Could use some Excel wisdom. I have tried tweaking examples given, but am still struggling. I need to sum data for each month based on a name using 2 tables:
    --Table 1--
    Jan Feb Mar...
    A 5 8 6
    B 2 6 9
    C 3 5 12

    --Table 2--
    A Bob Smith
    B Nancy Jones
    C Bob Smith

    Based on the name, I need a cell to sum all the values associated with the name for the month. So, in the example above, given "Bob Smith", the cell would return a value of 8 for January. I tried SUM & VLOOKUP and then MATCH & INDEX combos, and cannot make it work. Can someone kindly advise? Thank you.

  30. Thank you!

  31. Hey,
    Please help me how to solve this by using v look up.

    01/01/1991 Andy
    02/03/1991 Josepf
    01/04/1990 John
    05/07/1989 Cathy
    01/12/1990 Ray
    03/08/1990 Edmond
    03/07/1988 Steve
    03/03/1987 Peter

    Want to get the names of the person who born in the year 1990 by using Vlookup.

    Thanks

  32. Hi. I have 16 ranges to test a value and return 16 different values For example, if d2 is between 115 and 120, return 2400. But if d2 is between 110-115, return 2300, and so on.....
    I attempted to next if (or(d2>115, d2<=120), 2400, if(....... but I keep getting the error of too many arguments.

    SO, if there a better way or can I use the look up if I put my ranges in another sheet?

    Thanks so much for the help.

  33. Hii
    Can you pls hlp me out.
    I req to make a database of commodities sent, their actual rate, quantity consuned, selling price, profit etc.
    I am not able to make calculations hoe to use vlookup pls help me out. Its very imp.

    Thanx

  34. Can anyone help me solve this. I am a carpenter and have spreadsheet that will compile a list of materials, lengths, and quantities. I want to organize it from largest to smallest, and (type column, then length column) and consolidate like pieces in same row with quantities summed. Ty in advance Norm
    TYPE LENGTH QUANT
    4 X 12 15 1/2 1
    6 x 6 27 1/2 2
    4 X 12 39 1/2 3
    4 X 12 51 1/2 4
    6 X 12 63 1/2 5
    4 X 12 75 1/2 6
    4 X 12 87 1/2 7
    4 X 8 99 1/2 8
    4 X 12 15 1/2 9
    6 X 4 27 1/2 10
    4 X 12 39 1/2 11
    4 X 6 51 1/2 12
    4 X 12 63 1/2 13
    4 X 12 75 1/2 14
    4 X 10 87 1/2 15
    4 X 12 99 1/2 16
    4 X 12 15 1/2 17
    4 X 12 27 1/2 18
    6 X 14 39 1/2 19
    4 X 12 51 1/2 20
    4 X 12 63 1/2 21
    4 X 12 75 1/2 22
    4 X 6 87 1/2 23
    4 X 12 99 1/2 24

  35. It was really that easy, and right after I posted this. I figured it out. Thanks!

  36. Hi..I am stuck..this seems so simple but I can't figure it out. I have a main table with a product ID and a cell for freight. Each month I run a report and one particular product ID might have mulitple entries (vertically in the sheet) with a specific freight charge, I need to create a formula to look at the product ID # in my main table and in that one cell next to it total the freight associated with that product ID# from the report I run each month. for example:
    A1 A2
    Product ID Freight
    1 Formula returns freight total
    2
    3
    4
    5
    6

    Lookup Table
    Product ID# Freight
    1 $2.50
    1 $3.50
    5 $5.00
    5 $5.00
    1 $5.00
    6 $2.50

    So for Product ID# 1 - I need the formula to return $11.00 in the one cell for that product ID# in the main table. For some reason I just can't get it to return even a number.

    Thanks for your help

  37. Hi Svetlana,

    Thank you for nice tip. I used SUMPRODUCT to avoid using curved brackets.
    My question is about array {2;3} , why I cannot use variables instead of numbers? Like {A1;A2}, function returns error in this case.
    Thank you

  38. plz can some one tell me i have two columns one contains serial numbers and other sum random values. i want to make a formula that if a user enters a serial number the sum of random number corresponding to it and all the numbers above it should be added and displayed in a cell. the input can be varied. plz can in need of help

  39. Hello, I have a vlookup formula that is working but i want to add a sum to it to not just bring in one value but the sum of those that match. i've been reading lots of stuff online about sumif, sumproduct, vlookup, index, match and i'm so confused. Perhaps mine is difficult because i need the transpose?
    First Tab
    Cost Center Totals
    1
    2
    3
    4

    Second Tab
    Cost Centers Totals
    1
    1
    2
    2
    2
    2
    3
    3

  40. hi,
    Can anyone give the the guidance for the SUMIF formula, i have put SUMIF formula link from other workbook. after save and closing the work sheet. i tried to open the master file. the link was not updated and showing "#VALUE!"

    If i again open the supporting work sheet, then the link was showing the correct value.

    How to fix it the issue?

    i have pur the following formula
    =SUMIF('[Sheet1.xls]SUMMARY'!$D$4:$E$33,A347,'[Sheet1.xls]SUMMARY'!$E$4:$E$32)

  41. Hi Guys,
    You People are doing a great job, I like the way you are helping people and sorting out their problems individually, this forced me to share my problem with you people.

    I made a workbook consisting of 30 sheets for gas station, i want to keep daily record of that, so i need to know how can i make a final sheet and link those 30 sheets together so they could give me total sales and total expenses of 30 days in the Final sheet ?

    Thanks in advance, Looking forward for your help.

  42. I have two files of data. One file contains outstanding loans, only one loan for each customer. The other file contains all the customer loans paid ( a customer could have numerous loans paid). The customer can only have one loan outstanding. I am trying to make sure that the customer didn't have two loans outstanding at the time. To make sure they didn't have an outstanding from one of the paid loans when it was outstanding. Can anyone please Help?

  43. Hi I have a question. i have 2 excel 2010 sheets. the one sheet collects all the data. the second sheet i want the data from the second sheet to be carried over, but this is where i have a problem the data sheet 1, when the data has transfered to the second sheet i want it to close the sheet 1 off so that i can process a new months work on it. the data from the first sheet will have to look for a employee no and his specific salary amount and carry that to a 12 month report and place it in that month. when this is done i want to close of the sheet so that the data in sheet 2 does not change when i clear the sheet 1 (like a roll over clearing the one sheet but keeps the record of it on sheet 2. what do you suggest i use and do i need a vbs and macros for this.

  44. I have an inventory table that I would like to create a summary page for. Consisting of:

    Column A Column B Column C
    Qty Rec'd Part Number Total Rec'd

    There are several rows of the same part number containing different qty's rec'd in each. I would like to be able to have a formula that would search the whole (same) worksheet for that part number and total the qty's in Column C.

    Thank you in advance for your help ☺

  45. hello!
    i want to use add the values for the particular item appearing several times in a table. how is ti possible. see table below. for example A was produced two times. i want to use count function to know how many times A was porduced and then add the quantity for A is one location.

    element Prdouced
    A 5
    B 3
    X 5
    X 15
    B 11
    A 20

  46. HI SVETLANA
    I have budgeted data in one sheet having Budgeted amount of all account cods and actual data having a lot number of same codes in other sheet, I want to link other sheet with budgeted data and Want to sum up all the amounts of same codes in second sheet actual data and show parallel in next column of budget sheet. Can you please advise how can I do?

    For Example
    Sheet One Budget Data
    Account # Budget Amount Actual Amount

    1 50000 sum of account#1 from second sheet (actual data )
    2 15000 sum of account#2 from second sheet (actual data )
    3 30000 sum of account#3 from second sheet (actual data )

    Second sheet actual data
    Account # Budget Amount
    1 5000
    2 2000
    1 6000
    1 3000
    3 4000
    2 5000
    1 2000
    3 3000
    2 7000

    regards

    Khan Afzal

  47. Hi Svetlana Cheusheva and thanks for the extremely helpful tutorial. Referring to the first table above, I'd like to know whether we can have a formula that tells us the average sales for a particular product within a particular time period. For e.g.,what was the average sales of Oranges during the period March to June?
    Similarly, on changing the words "Oranges","March", and "June" in 3 adjacent cells, to, say, "Lemons","April","August", I get the result of "Average sales of Lemons for the Period April to August".

  48. Sheet 1
    Collected by Designation Ref CR/DR Credit

    S&L Head Of Unit 8089 C 250,000
    Hannington Manager 8090 C 400,000
    refund Team Leader 8091 C 471,805
    PSU Officer 8092 C 488,583
    Alex Head Of Unit 8093 C 500,000
    Hannington Manager 8094 C -
    refund Team Leader 8095 D 157,261
    CL Officer 8096 D -
    Joseph Head Of Unit 8097 C 300,000

    Summary sheet

    Name Grade Total

    Hannington Head Of Unit ......
    Alex Manager ......
    Joseph Team Leader ......
    Jimmy Officer ......

    I would like to get cummulative collection per collector in the summary sheet.

  49. Thanks for this insight. I request to be assisted I have two excell sheets both having a name and designation, I would like to summarise the amounts collected per name because we run a credit collections firm and we would like to award incetives.

    Joshua

  50. plz help me how to In this sheet A1 to F1 value are below 18 its is BOLD and G1 = total of A1:F1 and H1=percentage of G1
    i1= below 18 value of total numbers
    I want if i1=0 then show the value of H1 or average of G1 and If i1 is not euqal to zero(0) show value of i1 or below number of values

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)