Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page count if or countifs how do I do it?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2015, 09:35 AM
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
The formula works but I just realized that since this is to count grades and I need to count the grades that are >.70 but <than .79 to get how many students got a C grade, the formula you gave me counts >.70 and above. I tried playing around and used this

=(SUMPRODUCT((A5:A44="EE")*(G5:G44>0.77*(G5:G44<0. 79))))

but for some reason is counting all everything between 70 and 79 even though the A5:A44 or doing something else because is giving me a wrong counting
Reply With Quote
Reply

« Previous Thread | Next Thread »


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 03:58 AM.

Contact Us - Privacy Statement - Top

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