Hello everyone,
I have a question:
how do I count the number of cells that contain an even number?
thank you
Alasque
Try
=SUMPRODUCT((MOD(A1:100,2)=0)+0)
A1:A10 should be replaced by the range that you need to check
Last edited by royUK; 09-15-2010 at 10:11 AM.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks