Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-10-2015, 12:51 PM
piper7971 piper7971 is offline count if or countifs how do I do it? Windows Vista count if or countifs how do I do it? Office 2007
Advanced Beginner
count if or countifs how do I do it?
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default count if or countifs how do I do it?

Hi!
Yesterday, someone help me with a formula which is working super.
Now I realized that I need to count the cells which I applied a conditional formatting. I know this can only be accomplish with Vba but I don't want to use it. So I was thinking if count if or ifs can help me. The problems is I have tried and is not working. Here is what I want



I have this for the conditional formatting to turn the cell red
=AND($A5<>"",$G5<0.7)

Is it possible to count all the cells in a row A5:A44<>"",G5:G44<.07 that meet the same conditions?

Thanks for always helping
Liz
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
count if or countifs how do I do it? COUNTIFS returning Value Error ubns Excel 1 04-16-2015 02:00 PM
Need help building COUNTIFS solution 676nova Excel 9 02-27-2015 12:50 PM
COUNTIFS Help Needed OTPM Excel 2 04-09-2014 08:32 AM
count if or countifs how do I do it? Countifs and Sumproduct Algo Excel 6 11-13-2012 07:44 AM
countifs? sonyaturpin Excel 1 05-23-2012 08:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft