=SUM(IFERROR(A:A/A:A,0))
then CTRL + SHIFT + ENTER
where A:A is the column that your stuff is in
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):
=COUNTIF(B3:B7, "<6")
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")))
214 views
Usually answered in minutes!
i have same problem discreption is below
DATE
AMOUNT
01.05.08
251948
02.05.08
562733
02.05.08
10890
03.05.08
775800
03.05.08
482620
05.05.08
1899356
Up to 1 LACS
Can u suggest me a formula in to this box
Between 1 to 2 lacs
Can u suggest me a formula in to this box
Between 2 to 4 lacs
Can u suggest me a formula in to this box
Between 4 to 5 lacs
Can u suggest me a formula in to this box
Between 5 to 6 lacs
Can u suggest me a formula in to this box
Between 6 to 8 lacs
Can u suggest me a formula in to this box
×