Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
SUMIF function help | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions |