Windows 7 Forums

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

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 System SpecsSystem Spec

08 Oct 2013   #2
Microsoft MVP

Windows 7 Ult. 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 System SpecsSystem Spec
09 Oct 2013   #3

Windows 7 64bit
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 SpecsSystem Spec

15 Oct 2013   #4

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

My System SpecsSystem Spec

 Excel 2007 function CountIf

Thread Tools

Similar help and support threads
Thread Forum
Excel 2007 (MS Office 2007 enterprise)
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells. I have cleared the cells formatted the number but it still keeps on...
Microsoft Office
AERO function not working for MS Excel 2007
Hi all; My Aero function seems not to be working for MS Excel 2007. AERO is working on all other apps. When launching MS Excel 2007 as a single app, the Aero function is working as shown below. However, when launching more than ONE MS EXcel 2007 file, the AERO function ceased to work for MS...
General Discussion
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
directory xla in Excel 2007
When I was using XP Pro and Excel 2003 then later 2007 I was able to insert the directory xla add in that allowed me to click the add in option it would let me choose a folder or directory to copy into Excel. Now that I am using Windows 7 Pro and Excel 2007 I have not been able to find a way to...
Excel 2007
Hi there, I just installed Office 2007, used to have 2003 and now I cannot save my shared files anymore I get an error message when I try to log in stating that an unexpected file protection occured by System Admin. Then when I try to save a file I get an error message saying that I violated...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office

Our Sites

Site Links

About Us

Find 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 18:41.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App