software

Hi Within Excel I want to be able to run the following formula. I want excel
to do the following in laymans terms

We have a coloumn of figures. I want excel to look through the coloumn and
if any of the figures match I want to add a value on to the original value !

Hope that makes sense and hope someone can help

Cheers

You could do this with a pivot table.

quot;Dave Edinburghquot; lt;Dave gt; wrote in message
...
gt; Hi Within Excel I want to be able to run the following formula. I want
gt; excel
gt; to do the following in laymans terms
gt;
gt; We have a coloumn of figures. I want excel to look through the coloumn and
gt; if any of the figures match I want to add a value on to the original value
gt; !
gt;
gt; Hope that makes sense and hope someone can help
gt;
gt; Cheers
Hi Dave

Do you mean COUNTIF()
In Cell B1 enter the number you are looking for, say 5
in C1
=COUNTIF(A:A,B1)
will return the number of 5's in column A.
Is this what you mean?

--
Regards

Roger Govierquot;Dave Edinburghquot; lt;Dave gt; wrote in
message ...
gt; Hi Within Excel I want to be able to run the following formula. I
gt; want excel
gt; to do the following in laymans terms
gt;
gt; We have a coloumn of figures. I want excel to look through the coloumn
gt; and
gt; if any of the figures match I want to add a value on to the original
gt; value !
gt;
gt; Hope that makes sense and hope someone can help
gt;
gt; Cheers