read non specified text to return numerical value

I know I've seen this before; did a bunch of searches and cannot find it.


I need to read a column range to see if it has any value in it. It will be a numerical value, but totally random.


I need it to sum the amount of times a value is in the column.

Originally Posted by redneck joe

I know I've seen this before; did a bunch of searches and cannot find it.


I need to read a column range to see if it has any value in it. It will be a numerical value, but totally random.


I need it to sum the amount of times a value is in the column.

Do you meant to count the items? - 'sum' means to add them together.

To count the occurance of '5' in column A:

=COUNTIF(A:A,5)

or

=COUNTIF(A1:A999,5)

etc

hth
---

sorry for not being clear.

The column will be reading for something in the cell - it may have "something", may not.

Then I need to know how many times "something" is in there.


The "something" will be a number, but random numbers with no duplicates.

Below would be column A with 8 cells in it, five of them containing "something" and three blank cells. I need to return a result of "5"


2
(blank cell)
12
(blank cell)
(blank cell)
16
1
4

Originally Posted by redneck joe

sorry for not being clear.

The column will be reading for something in the cell - it may have "something", may not.

Then I need to know how many times "something" is in there.


The "something" will be a number, but random numbers with no duplicates.

Below would be column A with 8 cells in it, five of them containing "something" and three blank cells. I need to return a result of "5"


2
(blank cell)
12
(blank cell)
(blank cell)
16
1
4

=counta(A:A)
will return a count of every cell with ANYTHING in it in column A

so, I was trying to mak it WAY too hard....

thanks



Care to help on a rounding question?


Need to round to the nearest 25 cents on formula.

Have cell containing $100,
have cell containing 32.4%,
formula will return $32.40 but I need it to read $32.50.
I will then calculate a total from multiple of these, and it needs to be a total of the rounded number, not actual number...

Originally Posted by redneck joe

so, I was trying to mak it WAY too hard....

thanks



Care to help on a rounding question?


Need to round to the nearest 25 cents on formula.

Have cell containing $100,
have cell containing 32.4%,
formula will return $32.40 but I need it to read $32.50.
I will then calculate a total from multiple of these, and it needs to be a total of the rounded number, not actual number...

rounding to cents is kind of ugly
=ROUND(A1/0.25,0)*0.25
essentially i'm rounding the number of quarters you have, then multiplying the number of quarters you have by the value of a quarter

sweet.....


Last question - what language is that on your signature?

latin, i believe.
someone else on here had a latin sig that i didn't understand so i googled it. and got a list of sites with funny sayings...

didn't think to google the latin - I tried an online translator and it didn't work...


and the answer is about 4 truckloads....


Thanks for all your help.

np. thanks for the advice as I'm about 3 trucks short

Originally Posted by MDubbelboer

np. thanks for the advice as I'm about 3 trucks short

I would have interpreted that as 1 truck, 4 loads, which shows what a sad world I live in.

---