Hi I want to be able to look at two columns and set a criteria to count. I want to look at column A and if its blank then look at column B and if it has a value of more than 0 then count.
A B
1 1.00
2 Yes 4.78
3
4 5.00
5 Yes 4.89
6 11.99
So this example would count 3
If that all makes sense.
David
Last edited by EXCELNEWCOMER; 01-15-2010 at 02:22 PM.
Try
=Sumproduct(--(A1:A100=""),--(B1:B100>0))
adjust ranges to suit
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.
Many thanks for your help. If you have time could you explain how each bit works ?
David
Originally Posted by NBVC
Check out this site for a good read: http://www.xldynamic.com/source/xld.SUMPRODUCT.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks