+ Reply to Thread
Results 1 to 3 of 3

Formula wanted for a table please

  1. #1
    Registered User
    Join Date
    03-21-2005
    Posts
    8

    Formula wanted for a table please

    Hi,
    From the list of data below whereby company type A ordered 5, 9, 33, 66 and 72 units, Type B ordered 21 units, Type C ordered 38, 39, 95 and 98 units,
    Capture1.JPG

    What formula do I need in the table below to bring up the results for each range of 10 units currently manually keyed there please ?

    i.e Range 0 to 10, Type A made 2 orders in this range. What is the formula to bring up the result of 2?
    and I would like to extrapolate that formula to fill the Table between cells K2 and M11


    Thank You




    Wanted Results:

    Capture2.JPG

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Formula wanted for a table please

    Try this

    =SUMPRODUCT((K$1=$F$2:$F$11)*($C$2:$C$11>$I2)*($C$2:$C$11<=$J2))

    See the file attached..
    Attached Files Attached Files
    Cheers!
    Deep Dave

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,207

    Re: Formula wanted for a table please

    Try in K2 (copy across and down)

    =COUNTIFS($F$2:$F$11,K$1,$C$2:$C$11,">=" &$I2,$C$2:$C$11,"<=" &$J2)

    BUT change ranges to 0-10, 11-20, 21-30 etc

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Wanted to know if data already exists in Table
    By SriramDorai in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2014, 01:48 PM
  2. Formula wanted
    By George R in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-24-2013, 01:21 PM
  3. [SOLVED] Macro Wanted VBA Table to List with more than 3 columns
    By carpediem_3112 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-18-2013, 12:50 PM
  4. Replies: 1
    Last Post: 06-17-2012, 03:26 PM
  5. Help wanted to create a formula
    By flds in forum Excel General
    Replies: 1
    Last Post: 02-03-2010, 07:31 PM
  6. Formula help wanted
    By LPlate in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2009, 07:41 AM
  7. No Pivot Table Totals Wanted
    By robertjtucker in forum Excel General
    Replies: 1
    Last Post: 08-02-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1