Question about Microsoft Excel for PC
Lets say your data (fruits) is in range "A1:A8" and you need to know that how many total numbers are mangoes and Pinapples in them.
In Such case we can use the countif( ) function of Excel as following:-
=countif(A1:A8,"Mangoes")+countif(A1:A8,"Pinapples") <>
Hope this help.
Posted on May 03, 2008
Just to point out, if you are trying to get a count of criteria that is based on 2 or more conditions being met, then things get a bit more complicated. COUNTIF doesn't support boolean concatenations of conditions, ie:
=COUNTIF(A1:A8,">2 and <8")
where A1:A8 holds a range of numbers 1 through 8.
This won't work.
So creativity will be called for if that is the case with you. Your approach will be dictated by the exact nature of the criteria and data.
Posted on Apr 24, 2008
P.S. On-line COUNTIF doc is here.
×
Lets say your data (cars) is in range "D1:D21".
You need to know how many are Dodge and Ford in cell E1.
=COUNTIF(D1:D21,"Dodge") + COUNTIF(D1:D21,"Ford)
Hope this helps.
Posted on Apr 23, 2008
Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!
Posted on Jan 02, 2017
Nov 20, 2013 | Microsoft Excel 2010
Jun 12, 2009 | Microsoft Excel for PC
Apr 10, 2009 | Microsoft Excel for PC
Jan 21, 2009 | Microsoft Office Excel 2003 for PC
Dec 21, 2008 | Microsoft Excel for PC
Nov 26, 2008 | Microsoft Excel for PC
May 27, 2008 | Microsoft Excel for PC
May 27, 2008 | Microsoft Windows Vista Ultimate Edition
Apr 22, 2008 | Microsoft Office Professional 2007 Full...
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
188 people viewed this question
Usually answered in minutes!
Just wanna say Cheers to mcc99 & CNewton2 for posting a solution to my problem with an Excel formula. Being a first timer to this i didnt give enough detail to my problem so im going to try again, hope i get the same response.
laters Jayc3p0
countif(A1:A5,"apple",2)
if(and(m1>=35,m2>=35,m3>=35,"pass","fail"))
×