| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum values based on Text
I have 2 columns, one contains "Pod 1", Pod 2" with each row having a pod
value. I need to add the numbers in a different column when the value in the Pod column matches my designator. I have 3 rows with Pod 1 so I would add the 3 numbers in a different column. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum values based on Text
Mitchell,
This what you mean ? =SUMIF(A1:A8,"Pod 1",B1:B8) NickHK "Mitchell" ... I have 2 columns, one contains "Pod 1", Pod 2" with each row having a pod value. I need to add the numbers in a different column when the value in the Pod column matches my designator. I have 3 rows with Pod 1 so I would add the 3 numbers in a different column. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum values based on Text
Thanks worked perfectly, I was caught in a loop trying things that were way
too complex. "NickHK" wrote: Mitchell, This what you mean ? =SUMIF(A1:A8,"Pod 1",B1:B8) NickHK "Mitchell" ... I have 2 columns, one contains "Pod 1", Pod 2" with each row having a pod value. I need to add the numbers in a different column when the value in the Pod column matches my designator. I have 3 rows with Pod 1 so I would add the 3 numbers in a different column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add values based on text color with the criteria of a date | Excel Worksheet Functions | |||
| cell to have comma-delimited values based on text | Excel Worksheet Functions | |||
| return values from an array based on matching text value | Excel Worksheet Functions | |||
| Create a 'text' string based on whether values appear in other cel | Excel Worksheet Functions | |||
| calculating values based on text in other sheets | Excel Programming | |||
Linear Mode
