| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Function
have a spredsheet that has a column of colours related to work, colours are
in text format i.e. Red, white the a second column has numbers. I would like to use a function that can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and D25.7.10. has value but the imbetween cells have different colours. I need to be able to use a some to only add up the value in column D which relate to the word Red in column B. Can anyone help on this one. Thank you -- pk |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function
=SUMIF(B2:B10,"Red",D2:D10)
PK wrote: have a spredsheet that has a column of colours related to work, colours are in text format i.e. Red, white the a second column has numbers. I would like to use a function that can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and D25.7.10. has value but the imbetween cells have different colours. I need to be able to use a some to only add up the value in column D which relate to the word Red in column B. Can anyone help on this one. Thank you -- pk |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function
Look at SUMIF and SUMPRODUCT functions
"PK" wrote: have a spredsheet that has a column of colours related to work, colours are in text format i.e. Red, white the a second column has numbers. I would like to use a function that can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and D25.7.10. has value but the imbetween cells have different colours. I need to be able to use a some to only add up the value in column D which relate to the word Red in column B. Can anyone help on this one. Thank you -- pk |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function
No need to double-post - your answers are now fragmented.
Pete On Oct 25, 7:06 pm, PK wrote: have a spredsheet that has a column of colours related to work, colours are in text format i.e. Red, white the a second column has numbers. I would like to use a function that can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and D25.7.10. has value but the imbetween cells have different colours. I need to be able to use a some to only add up the value in column D which relate to the word Red in column B. Can anyone help on this one. Thank you -- pk |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function
Perfect
Thank you -- pk "JW" wrote: =SUMIF(B2:B10,"Red",D2:D10) PK wrote: have a spredsheet that has a column of colours related to work, colours are in text format i.e. Red, white the a second column has numbers. I would like to use a function that can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and D25.7.10. has value but the imbetween cells have different colours. I need to be able to use a some to only add up the value in column D which relate to the word Red in column B. Can anyone help on this one. Thank you -- pk |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function
Perfect
Thank you -- pk "Toppers" wrote: Look at SUMIF and SUMPRODUCT functions "PK" wrote: have a spredsheet that has a column of colours related to work, colours are in text format i.e. Red, white the a second column has numbers. I would like to use a function that can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and D25.7.10. has value but the imbetween cells have different colours. I need to be able to use a some to only add up the value in column D which relate to the word Red in column B. Can anyone help on this one. Thank you -- pk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Linear Mode
