Good evening people,
With this vba code i count all cells with a value higher then 2.
I want to ask if someone here knows a formula for doing this.
Thank you in advance.
Hennie
Please Login or Register to view this content.
Good evening people,
With this vba code i count all cells with a value higher then 2.
I want to ask if someone here knows a formula for doing this.
Thank you in advance.
Hennie
Please Login or Register to view this content.
Last edited by henneman; 07-20-2010 at 02:36 PM.
In C9 you could use:
=SUMIF(C3:C7,">2",C3:C7)
Copy that to D9, E9 and F9.
You don't need to reference the same range that you are summing and searching criteria...
i.e. =SUMIF(C3:C7,">2") will do.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hello Paul,
Thank you very much for this formula!
Hennie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks