Question about Oracle 10g Database Standard (ODBSEONUPP0)
then CTRL + SHIFT + ENTER
where A:A is the column that your stuff is in
Posted on Oct 23, 2012
You may want COUNTIF if you're specifying criteria. For instance, if my prices are found in b3 to b7, here's a formula that will find all those that are less than 6 ($6.00):
If you're using multiple criteria, such as you want to find all the prices that are greater than $5 and less than $8, the following will accomplish it. (The ABS gives you the absolute value of the result, in case the smaller number is first.)
=ABS(SUM(COUNTIF(B3:B7, ">5") - COUNTIF(B3:B7, "<8")))
Posted on Nov 07, 2007
Tips for a great answer:
on Nov 11, 2013 | Microsoft Excel Business & Productivity...
Apr 10, 2009 | Microsoft Excel for PC
Feb 25, 2009 | Business & Productivity Software
Dec 21, 2008 | Microsoft Excel for PC
Nov 24, 2008 | Microsoft Office 2003 Basic Edition...
Sep 14, 2008 | Business & Productivity Software
Jul 14, 2008 | Business & Productivity Software
Jun 18, 2008 | Business & Productivity Software
Dec 17, 2007 | Business & Productivity Software
161 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: