| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I specify cell contents for the Criteria in SUMIF?
I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it can be done. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I specify cell contents for the Criteria in SUMIF?
This can be done. Something like:
=SUMIF(A1:A10,C1,B1:B10) This checks for the value of C1 in the range A1:A10, then adds B1:B10. HTH, Elkar "Michael" wrote: I am trying to use the cell contents as the Criteria specification as opposed to a fixed text operator and cannot seem to figure out how to do it or if it can be done. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I specify cell contents for the Criteria in SUMIF?
for other than equal condition, use:
=SUMIF(A1:A10,"" &C1,B1:B10) "Elkar" wrote: This can be done. Something like: =SUMIF(A1:A10,C1,B1:B10) This checks for the value of C1 in the range A1:A10, then adds B1:B10. HTH, Elkar "Michael" wrote: I am trying to use the cell contents as the Criteria specification as opposed to a fixed text operator and cannot seem to figure out how to do it or if it can be done. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I specify cell contents for the Criteria in SUMIF?
"Michael" wrote: I am trying to use the cell contents as the Criteria specification as opposed to a fixed text operator and cannot seem to figure out how to do it or if it can be done. I am getting an error with the following when trying to do a logical operator: =SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288) I have tried it with and without the quotes and still get an error message. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I specify cell contents for the Criteria in SUMIF?
I am getting an error with the following when trying to do a logical
operator: =SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288) I have tried it with and without the quotes and still get an error message. Concatenate the "" with the contents of $D$3... =SUMIF($N$8:$N$288,""&$D$3,$D$8:$D$288) Rick |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I specify cell contents for the Criteria in SUMIF?
As per my previous reply:
=SUMIF($N$8:$N$288,"" & $D$3,$D$8:$D$288) "Michael" wrote: "Michael" wrote: I am trying to use the cell contents as the Criteria specification as opposed to a fixed text operator and cannot seem to figure out how to do it or if it can be done. I am getting an error with the following when trying to do a logical operator: =SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288) I have tried it with and without the quotes and still get an error message. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I specify cell contents for the Criteria in SUMIF?
"Rick Rothstein (MVP - VB)" wrote: I am getting an error with the following when trying to do a logical operator: =SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288) I have tried it with and without the quotes and still get an error message. Concatenate the "" with the contents of $D$3... =SUMIF($N$8:$N$288,""&$D$3,$D$8:$D$288) Rick Super! Thanks!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding cell contents based on certain criteria | Excel Discussion (Misc queries) | |||
| Finding cell contents based on certain criteria | Excel Discussion (Misc queries) | |||
| Sumif with 2 cell criteria | Charts and Charting in Excel | |||
| sumif using other cell contents as workbook | Excel Discussion (Misc queries) | |||
| Displayed contents of cell in target row if column criteria is met | Excel Worksheet Functions | |||
Linear Mode
