+ Reply to Thread
Results 1 to 3 of 3

Count IF returning spill

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Sydney
    MS-Off Ver
    365
    Posts
    16

    Count IF returning spill

    Hi Community

    I been trying for 2 days this formula but always return SPILL

    I need the graph on the tab 'KPI' get the number from the other 2 tables automatically.

    pex. on 'KPI' D21 - I need the total numbers of orders with "Schedule date" for 21/04 summing the one on "Schedule" and "Despatched" table.

    ps: We use the table schedule and after the order is done we move to despatched.

    The logic that I'm using to get the data on "Despatched" table

    KPI!B24 - count dates from the colum 'Despatched'!G6:G50 that are equal to KPI!B23 "=COUNTIF(Despatched!G6:G50,B23)"

    but I still need to SUM with the orders from the "Schedule" table

    The logic that I'm thinking to get the ones that are still on Schedule table is

    "Find on the columm Schedule!B6:B50 the orders that have the schedule date (Schedule!A6:A50) for 21/04 and count them and sum"

    WORNG FORMULA USED =COUNTIF('Despatched!$G$6:$G$50,B23)+IF('Schedule 2020'!$A$6:$A$50='KPI - Order on time'!B23,COUNTIF('Schedule 2020'!$B$6:$B$50,B23))

    To orders finished on time (KPI!A25) I need to compare on Despatched table the Schedule date and the Despatched date and sum, which I think with the help above I translate to this situation.

    If you have any other logic that I can use here to sum these number would be very helpful as well.

    Thank you all.
    Attached Files Attached Files
    Last edited by vini.v4; 04-22-2020 at 10:41 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,975

    Re: Count IF returning spill

    I suggest you read up on the functions COUNTIFS() and SUMIFS()
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    11-12-2019
    Location
    Sydney
    MS-Off Ver
    365
    Posts
    16

    Re: Count IF returning spill

    the closest that I get was summing the numbers on collumm B using:

    =SUMIFS($B$6:$B$49,$G$6:$G$49,$A$44)

    but I need the formula count the cells instead

    Count the cells $B$6:$B$49 when $G$6:$G$49 is equal to $A$44.

    I dont know how to do this using counting

    Also tried the below with no success
    =IF($G$6:$G$49=$A$44, COUNT($B$6:$B$49))

+ 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. [SOLVED] Count smallest two against a figure in another column and use logic to get true or false
    By MD PERVEZ KHAN in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2015, 06:54 AM
  2. [SOLVED] Output Conditional Logic Count to Cell
    By endly in forum Excel General
    Replies: 7
    Last Post: 07-12-2015, 12:26 PM
  3. Difficult Logic- recognise and count groups
    By Mariner111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 09:44 AM
  4. Count based on complex logic
    By dtrimble in forum Excel General
    Replies: 7
    Last Post: 08-23-2011, 08:47 PM
  5. Using count() with embeded logic
    By cpurick in forum Excel General
    Replies: 4
    Last Post: 11-19-2006, 10:59 PM
  6. logic that returns a count
    By d_kight in forum Excel General
    Replies: 8
    Last Post: 05-17-2006, 07:35 PM
  7. Count logic question
    By ACDenver in forum Excel General
    Replies: 7
    Last Post: 08-17-2005, 12:05 PM

Tags for this Thread

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