Join Forum | Login | Today's Posts | Tutorials | Windows 10 Forum | Windows 8 Forum

 Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

# Windows 7: Excel 2007 function CountIf

 08 Oct 2013 #1 eagle Windows 7 64bit 9 posts 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 System Specs
 .
 08 Oct 2013 #2 Golden Windows 7 Ult. x64 19,432 posts South Australia 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: http://www.xldynamic.com/source/xld.SUMPRODUCT.html My System Specs
 09 Oct 2013 #3 eagle Windows 7 64bit 9 posts 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 System Specs
 .
 15 Oct 2013 #4 TanyaC Linux Mint 17 Cinnamon | Win 7 Ult x64 794 posts Melbourne, Australia Try This {=COUNT(A1:A1000)-COUNT(IF(MOD(A1:A1000,3),A1:A1000))} 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 hth My System Specs