| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull value from c8 but only if a8 = a certain value
I don't know if this is possible, but for reference list I need to use an IF
statement for an entire colum to see whether a value is used, and then if it is used, to total the number that is entered two cells over. How i really want it to read is, for example, if column a = "meetings", then add the time that is entered into the cell two colums over. The "meetings" can be entered anywhere in the column from row 1 through 20 and wherever it is entered you would need to pull the value from the same row 1 through 20 in the 2nd column. Hope that makes sence. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I pull value from c8 but only if a8 = a certain value
The SUMIF function should work for this:
=SUMIF(A1:A20,"meetings",C1:C20) HTH, Elkar "Hoya97" wrote: I don't know if this is possible, but for reference list I need to use an IF statement for an entire colum to see whether a value is used, and then if it is used, to total the number that is entered two cells over. How i really want it to read is, for example, if column a = "meetings", then add the time that is entered into the cell two colums over. The "meetings" can be entered anywhere in the column from row 1 through 20 and wherever it is entered you would need to pull the value from the same row 1 through 20 in the 2nd column. Hope that makes sence. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I pull value from c8 but only if a8 = a certain value
That did it...thanks a bunch
"Elkar" wrote: The SUMIF function should work for this: =SUMIF(A1:A20,"meetings",C1:C20) HTH, Elkar "Hoya97" wrote: I don't know if this is possible, but for reference list I need to use an IF statement for an entire colum to see whether a value is used, and then if it is used, to total the number that is entered two cells over. How i really want it to read is, for example, if column a = "meetings", then add the time that is entered into the cell two colums over. The "meetings" can be entered anywhere in the column from row 1 through 20 and wherever it is entered you would need to pull the value from the same row 1 through 20 in the 2nd column. Hope that makes sence. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull Out Last Name | Excel Worksheet Functions | |||
| Pull a value from another worksheet | Excel Worksheet Functions | |||
| Help for Harlan's Pull | Excel Worksheet Functions | |||
| PULL FUNCTION | Excel Worksheet Functions | |||
| Pull down lists | Excel Discussion (Misc queries) | |||
Linear Mode
