| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum values in cell based on another cell
I tried to find a solution by searching posts, but had no luck understanding
them. Here is sample table and then my question: A B C D 0 1 1 Tuesday 0 0 0 Monday 1 0 1 Monday 0 1 0 Friday I want to add the values in column A where column D="Monday" I am guessing it would be similar when counting the number of "1"s in column A when D="Monday Any help with this would be greatly appreciated. :Brandon: |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum values in cell based on another cell
Hi Brandon,
=SUMIF(D1:D4,"Monday",A1:A4) -- Kind regards, Niek Otten Microsoft MVP - Excel "Brandon P" <Brandon wrote in message ... |I tried to find a solution by searching posts, but had no luck understanding | them. Here is sample table and then my question: | | A B C D | 0 1 1 Tuesday | 0 0 0 Monday | 1 0 1 Monday | 0 1 0 Friday | | I want to add the values in column A where column D="Monday" | | I am guessing it would be similar when counting the number of "1"s in column | A when D="Monday | | Any help with this would be greatly appreciated. | | :Brandon: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum values in cell based on another cell
=SUMPRODUCT(A2:A5,--(D2:D5="Monday")) or
=SUMPRODUCT((A2:A5)*(D2:D5="Monday")) -- David Biddulph "Brandon P" <Brandon wrote in message ... I tried to find a solution by searching posts, but had no luck understanding them. Here is sample table and then my question: A B C D 0 1 1 Tuesday 0 0 0 Monday 1 0 1 Monday 0 1 0 Friday I want to add the values in column A where column D="Monday" I am guessing it would be similar when counting the number of "1"s in column A when D="Monday Any help with this would be greatly appreciated. :Brandon: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Changing values in a row based on a cell in the row. | Excel Discussion (Misc queries) | |||
Linear Mode
