| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional adding by checking status
Hi friends,
I want to add a column values only if the value have specific status. Ex: lets take 2 columns, A and B A column have numbers and B column has status for each number. Now i want to add column A values only if the status is Active for that value in B column. the result can be displayed in column C. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional adding by checking status
Hi,
Maybe this =SUMIF(B:B,"Active",A:A) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rajkiran Singh" wrote: Hi friends, I want to add a column values only if the value have specific status. Ex: lets take 2 columns, A and B A column have numbers and B column has status for each number. Now i want to add column A values only if the status is Active for that value in B column. the result can be displayed in column C. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Column Status on closing excel - Macro Needed | Excel Discussion (Misc queries) | |||
| Checking Filled Columns and Adding up value above | Excel Worksheet Functions | |||
| Status Bar - SUM function adding grouped cells | Excel Discussion (Misc queries) | |||
| Checking status of issues based on first two digits of a field | Excel Discussion (Misc queries) | |||
| Checking Client Status Prior to Save | New Users to Excel | |||
Linear Mode
