+ Reply to Thread
Results 1 to 14 of 14

Need Count cell range IF true another 2 cell ranges

  1. #1
    Registered User
    Join Date
    03-30-2016
    Location
    Srilanka
    MS-Off Ver
    2007
    Posts
    5

    Red face Need Count cell range IF true another 2 cell ranges

    Hi,

    I want to check if Column A contains word "Car" and Column B contains "Open" then Count Column "C" values and return it in Column D.

    Thank you

    sss.PNG

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Need Count cell range IF true another 2 cell ranges

    to count use countifs(A:A,"car",b:b,"open"). But I assume that you want something else and you haven't explained clearly.
    Click the * to say thanks.

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Need Count cell range IF true another 2 cell ranges

    What do you mean by 'Count Column 'C'"? Word 'Called' is in there.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Registered User
    Join Date
    03-30-2016
    Location
    Srilanka
    MS-Off Ver
    2007
    Posts
    5

    Re: Need Count cell range IF true another 2 cell ranges

    Hi Kokosek,

    Thanks for the advance.

    I mean I want to check IF Column A value (example "Car") and Column B Value(example "Open") then count the values in Column C

  5. #5
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Need Count cell range IF true another 2 cell ranges

    What do you mean by count value if in C2 is word 'Called'?
    It have to be counted as 1 (because exists)? If in C3 is 'No action' it have to be 'counted' as zero?

  6. #6
    Registered User
    Join Date
    03-30-2016
    Location
    Srilanka
    MS-Off Ver
    2007
    Posts
    5

    Re: Need Count cell range IF true another 2 cell ranges

    Yea kokosek, As u said It should be return counted value of Column C .

    Here In Column C has value "Called" so it means it has a value. So in Column D, it should be 1

  7. #7
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Need Count cell range IF true another 2 cell ranges

    said It should be return counted value of Column C
    First of all, makes no sense. Are you saying to count if a=car,b=open any values in C? or a=car,b=open,c=some value? Use countifs with 2 or 3 criteria.
    something like in post #2 or =countifs(a:a,a2,b:b,b2) or ==countifs(a:a,a2,b:b,b2,c:c,c2)

  8. #8
    Registered User
    Join Date
    03-30-2016
    Location
    Srilanka
    MS-Off Ver
    2007
    Posts
    5

    Re: Need Count cell range IF true another 2 cell ranges

    It's like this

    if a=car,b=open then count c

  9. #9
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Need Count cell range IF true another 2 cell ranges

    I am still confused but maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    solve you needs.

  10. #10
    Registered User
    Join Date
    03-30-2016
    Location
    Srilanka
    MS-Off Ver
    2007
    Posts
    5

    Re: Need Count cell range IF true another 2 cell ranges

    actually its not working friend.

    Here I attached the orriginal file. In first pic is the detail file and the second one is the summery. (I marked red) there need to show no wise( counting from Corrective Action ) how many action took for the MB Sales and Raised status . hope now is clear.

    01.PNG

    Attachment 650948

  11. #11
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Need Count cell range IF true another 2 cell ranges

    I give up so far....
    Maybe fact that is Friday and my brain start going on stand by for weekend.

  12. #12
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Need Count cell range IF true another 2 cell ranges

    Maybe fact that is Friday and my brain start going on stand by for weekend.
    Is not you, can assure you of that. The problem is in this thread.

    Try this, @Yroxmk : =countifs(a:a,"M/B Sales",E:E, "Raised",C:C,"<>")

  13. #13
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Need Count cell range IF true another 2 cell ranges

    Quote Originally Posted by PaulM100 View Post
    =countifs(a:a,"M/B Sales",E:E, "Raised",C:C,"<>")
    Where are 'car' and 'open' disappear?

  14. #14
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Need Count cell range IF true another 2 cell ranges

    I honestly have no clue. Is a simple countifs involved, but the OP makes it hard to resolve.

+ 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. Replies: 5
    Last Post: 11-17-2019, 02:55 PM
  2. [SOLVED] Find if cell value is in range of other workbook and if true, copy-paste an offset cell
    By Szechter in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2019, 01:54 PM
  3. [SOLVED] IF Statement on multiple cell ranges return true
    By Ratso in forum Excel General
    Replies: 1
    Last Post: 03-22-2018, 10:38 AM
  4. Replies: 6
    Last Post: 03-26-2016, 05:49 PM
  5. Replies: 2
    Last Post: 07-27-2014, 11:48 PM
  6. Replies: 1
    Last Post: 01-03-2014, 03:01 AM
  7. Copy range and autofill ranges dependent on cell count in column A
    By thylander in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2011, 09:26 AM

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