| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count a value in cell if the cell to the left has a certain Value
What formula can I write to count value in one cell if left cell value is a
certain criteria Ex. Column1 Column2 State farm 300 If Column has state farm count column 2's value. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count a value in cell if the cell to the left has a certain Value
If you mean summing the values from column B when Column A is "State Farm"
then: =SUMIF(A:A,"State Farm",B:B) "Staholly" wrote: What formula can I write to count value in one cell if left cell value is a certain criteria Ex. Column1 Column2 State farm 300 If Column has state farm count column 2's value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count characters within a cell to the left of "/" | New Users to Excel | |||
| How to select a cell to the left of the right aligned cell with th | Excel Discussion (Misc queries) | |||
| Limit character count in cell from left | Excel Discussion (Misc queries) | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
Hybrid Mode
