| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding values within multiply columns
I have a spreadsheet with 26 columns. In one columns A I have cost center
information. In Column B I have a A or L indicator. I want to add how many times a certain groupings of cost centers appear with "A". It could be anywhere from 1 to 7 cost centers per group. I have been using Sumproduct, but it does not work in this case for me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count values in two columns | Excel Discussion (Misc queries) | |||
| Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
| Conditional Formulae with non-numeric values across two columns | Excel Discussion (Misc queries) | |||
| Finding Min Cell values excluding zero in alternate columns | Excel Worksheet Functions | |||
| Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
Threaded Mode
