| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum numbers based on value in other cells
I'm trying to count populated cells in a column, based on values in another
column. As example, if Column D is populated as General, I want to count the number of occurances in Column E. Column D has multiple values. I've tried pivot tables, but it isn't producing what I need. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum numbers based on value in other cells
=COUNTIF(D:D,"General")
If you really meant sum E, then use =SUMIF(D:D,"General",E:E) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Lori" wrote in message ... I'm trying to count populated cells in a column, based on values in another column. As example, if Column D is populated as General, I want to count the number of occurances in Column E. Column D has multiple values. I've tried pivot tables, but it isn't producing what I need. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum numbers based on value in other cells
Have you tried funcion:
=IF(D:D="general",COUNTA(D:D)) Eva "Lori" wrote: I'm trying to count populated cells in a column, based on values in another column. As example, if Column D is populated as General, I want to count the number of occurances in Column E. Column D has multiple values. I've tried pivot tables, but it isn't producing what I need. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum numbers based on value in other cells
This returns a "Value" error. I populated the D string and the E string.
Any other thoughts? This seems like it should be simple!! "Eva" wrote: Have you tried funcion: =IF(D:D="general",COUNTA(D:D)) Eva "Lori" wrote: I'm trying to count populated cells in a column, based on values in another column. As example, if Column D is populated as General, I want to count the number of occurances in Column E. Column D has multiple values. I've tried pivot tables, but it isn't producing what I need. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to make certain cells required based on criteria | Excel Worksheet Functions | |||
| Adding numbers in cells based on colour | Excel Worksheet Functions | |||
| Macro to highlight cells based on content | Excel Worksheet Functions | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
Linear Mode
