+ Reply to Thread
Results 1 to 3 of 3

What does this formula mean?

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    1

    What does this formula mean?

    i was cracking my head for a formula (solution) to my problem

    I was trying to nest COUNTIFS into IF statement, but before I really cracked my head on how to combined it, I just miraculously hit enter and it showed me this

    =COUNTIFS($C$716:$C$3162,C716,$D$716:$D$3162,"Piccolo - Anthracite")*IF(K716="Capsules",E716,"0")

    First, I entered =IF(K716="Capsules",E716,"0")

    Then, I entered =COUNTIFS($C$716:$C$3162,C716,$D$716:$D$3162,"Piccolo - Anthracite") IF(K716="Capsules",E716,"0") [WITHOUT THE ASTERISK]

    Then, I hit enter it auto populates the ASTERISK in between the COUNTIFS and IF statement, and miraculously solved my problem LOL.

    Wonder what does that formula mean?

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: What does this formula mean?

    It counts if the values in C are c715 and D are "piccolo - Anthracite" if k7716="Capsules" it multiplies the result by E717. Otherwise it returns 0 although it would be better if it was written *IF(K716="Capsules",E716, 0)

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: What does this formula mean?

    I would note that it would be more efficient to only do the COUNTIFS when necessary though
    =IF(K716="Capsules",COUNTIFS($C$716:$C$3162,C716,$D$716:$D$3162,"Piccolo - Anthracite")*E716,0)
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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: 8
    Last Post: 09-22-2017, 05:41 AM
  2. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  3. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  4. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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