| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a range
Hi
i am trying to sum the time values of a fault against an operation column CA hold the operation identification column CB holds the fault column CC holds the time values eg CA CB CC op 5 limit fault 15 op 5 clamp 20 op 10 limit fault 10 op 5 limit fault 10 this should return op 5 limit fault 25 op 5 clamp 20 op 10 limit fault 10 can anyone help with a formula thanks kevin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum a range
=Sumproduct(--(CA1:CA100="op 5"),--(CB1:CB100 = "limit fault"),(CC1:CC100)
You can replace the values in "" with something like = C10 where C10 = "op 5" if you want it to be more generic. Just ensure that the ranges in each group of () are the same length. "kevcar40" wrote: Hi i am trying to sum the time values of a fault against an operation column CA hold the operation identification column CB holds the fault column CC holds the time values eg CA CB CC op 5 limit fault 15 op 5 clamp 20 op 10 limit fault 10 op 5 limit fault 10 this should return op 5 limit fault 25 op 5 clamp 20 op 10 limit fault 10 can anyone help with a formula thanks kevin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum a range
Have just replied to your other post - please do not multi-post.
Pete On Apr 3, 7:42 pm, "kevcar40" wrote: Hi i am trying to sum the time values of a fault against an operation column CA hold the operation identification column CB holds the fault column CC holds the time values eg CA CB CC op 5 limit fault 15 op 5 clamp 20 op 10 limit fault 10 op 5 limit fault 10 this should return op 5 limit fault 25 op 5 clamp 20 op 10 limit fault 10 can anyone help with a formula thanks kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Linear Mode
