LinkBack URL
About LinkBacks
Evening,
Any help would be appreciated. I would like to create a formula that :
Will count the number of times 7 is in column D, but only if the value in O is higher than zero.
Many thanks
Evening,
Any help would be appreciated. I would like to create a formula that :
Will count the number of times 7 is in column D, but only if the value in O is higher than zero.
Many thanks
Last edited by Cmorgan; 09-10-2014 at 04:04 PM.
maybe this (untested)
=countifs(D:D,7,O:O,">0")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this:
=COUNTIFS(D:D,7,O:O,">0")
Hope this helps.
Pete
Many thanks this works a treat
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks