sumif
 

I would like to use a cell's contents as the condition or ciriteria for the
function. I have been unable to make the formula work. I have the criteria as
"A5=1050" but get not results.
--
Thanks for any help.

sumif
 

=SUMIF(A2:A10,1050,B2:B10)

We assume that A2:A10 hold the values that might contain the 1050 and
B2:B10 are the values to be added.

Does this help?
Kostis Vezerides

Martin wrote:
I would like to use a cell's contents as the condition or ciriteria for the
function. I have been unable to make the formula work. I have the criteria as
"A5=1050" but get not results.
--
Thanks for any help.

sumif
 

With 1050 in A5:

=Sumif(B1:B100,A5)
Will total all cells in B1 to B100 that contain 1050.


=Sumif(B1:B100,A5,C1:C100)
Will total all cells in C1 to C100 that are in the same row as cells in B1
to B100 that contain 1050.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"Martin" wrote in message
...
I would like to use a cell's contents as the condition or ciriteria for the
function. I have been unable to make the formula work. I have the criteria
as
"A5=1050" but get not results.
--
Thanks for any help.