| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting & Calculating
If I have a column sorted by A B C and another respective col that has
numbers in it, how could I write a function that would add up all numbers that have a respective A in the first col? In other words I want to Sum (if any cell in col A = A, I want to add them up) ----------------- Scott |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting & Calculating
=SUMPRODUCT(--(A2:A100)="A"),B2:B100)
Or =SUMIF(A2:A100,"A",B2:B100) "Scotts" wrote: If I have a column sorted by A B C and another respective col that has numbers in it, how could I write a function that would add up all numbers that have a respective A in the first col? In other words I want to Sum (if any cell in col A = A, I want to add them up) ----------------- Scott |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting & Calculating
Perfect, thank you.
----------------- Scott "Toppers" wrote: =SUMPRODUCT(--(A2:A100)="A"),B2:B100) Or =SUMIF(A2:A100,"A",B2:B100) "Scotts" wrote: If I have a column sorted by A B C and another respective col that has numbers in it, how could I write a function that would add up all numbers that have a respective A in the first col? In other words I want to Sum (if any cell in col A = A, I want to add them up) ----------------- Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating, filtering, and sorting 5 year anniversaries? | Excel Discussion (Misc queries) | |||
| calculating | Excel Worksheet Functions | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| calculating | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Linear Mode
