+ Reply to Thread
Results 1 to 6 of 6

Count if but only after calculation

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    483

    Count if but only after calculation

    Hello All,

    I am stuck in a countif logic where i want to execute a formula to the value in a cell first and if the condition is met, add that to the count


    For example

    Name 1st Entry 2nd Entry
    A 100 84
    B 100 84
    C 100 84
    D 100 86
    E 100 86
    F 100 86
    G 100 86


    in this, first I want to calculate the percentage of 2nd entry compared to the 1st entry in the same row and if that is above 85%, then take that for counting.


    Like this, for the entire column, the total count after applying the formula should be 4

    Note: 1st entry wont be 100 always. Just gave that for easiness
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,073

    Re: Count if but only after calculation

    Try below formula
    =sumproduct(--(c1:c7>=b1:b7*85%))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,898

    Re: Count if but only after calculation

    Try this ...

    =SUMPRODUCT(--(C2:C8/B2:B8>0.85))

  4. #4
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    483

    Re: Count if but only after calculation

    WoW....

    Thanks..Both the formulas are working great...

    I was trying with the counif function only...

    Thank you both for your help

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,898

    Re: Count if but only after calculation

    You are welcome!

  6. #6
    Registered User
    Join Date
    02-28-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Count if but only after calculation

    Hi.

    I went through this. Nice to see the answers. But felt difficult about what it says! Why that -- in array means? Why it has to come as 4? What the solution means? I might be quite good at basic formulas. But having difficulty in understanding this. can anyone please explain this ?

    Thank you.

    Thilak N

+ 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. Simple Count Calculation
    By rbpd5015 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2013, 01:12 AM
  2. [SOLVED] Count rows based on calculation with their columns
    By matyicsapo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2012, 11:40 AM
  3. COUNT/COUNTIF function with date calculation
    By Jayana in forum Excel General
    Replies: 4
    Last Post: 05-28-2012, 01:19 AM
  4. Replies: 13
    Last Post: 01-24-2012, 09:38 AM
  5. Number of Days Count/Calculation?
    By JonHook in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2007, 05:32 PM
  6. conditional calculation with count feature
    By TomI in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-06-2007, 01:46 PM
  7. Replies: 5
    Last Post: 11-26-2006, 04:45 AM
  8. Calculation of row count
    By Alur in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-29-2005, 11: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