Excel 2007 function CountIf

  1. Posts : 8
    Windows 7 64bit

    Excel 2007 function CountIf

    I would like to know whether there is a possibility of using other functions in the search criteria argument of the CountIf Function that also refer to the cells in the domain to which CountIf is applied.
    The same question arises when using for example SumIf Function.

    Thanks a lot for your help

    Kind regards
      My Computer

  2. Posts : 19,384
    Windows 10 Pro x64 ; Xubuntu x64

    SUMPRODUCT is usually used to substitute a combination of SUMIF and COUNTIF. What exactly are you trying to determine in Excel? Can you upload an example spreadsheet?

    Have a read:
      My Computer

  3. Posts : 8
    Windows 7 64bit
    Thread Starter

    To Golden in connexion with CountIf

    Thank you very much for the link referring to "sumproduct". Since momentarily I have no much free time left, it will take a few days until I can read through it.

    I would like to do the following:

    Lets assume there is a column of numbers and one would like to count how many of them can be divided by a given number e.g. 3.

    The condition to be checked could be something like: number/3-round(number/3;0) = 0

    Now, what I would like to know is if such an expression can be directly combined with the countIf function (without introducing "artificial" columns), something like

    CountIf(A1:A1000; number in each cell/3-round(number in each cell/3;0) = 0)

    I hope my question is not too idiotic.
    Looking forward to your reply
      My Computer

  4. Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64

    Try This


    Don't type the curly braces, they will be added automatically

    This is an array formula so you have to press CTRL-SHIFT-ENTER at the end of the formula

    Last edited by TanyaC; 17 Oct 2013 at 07:30.
      My Computer


  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 04:20.
Find Us