| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total numbers in column where the row cell matches the search crit
Here is my scenario below. How do I get a total of the only values in column
B where row cell matches A in column A? A B 1 A 100 2 A 200 3 B 300 4 C 400 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total numbers in column where the row cell matches the search crit
Try the below formula..
=SUMIF(A:A,"A",B:B) If this post helps click Yes --------------- Jacob Skaria "Kane" wrote: Here is my scenario below. How do I get a total of the only values in column B where row cell matches A in column A? A B 1 A 100 2 A 200 3 B 300 4 C 400 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Include varying cell references in formulas based on changing crit | Excel Worksheet Functions | |||
| is there a formula to add numbers in a range based on several crit | Excel Discussion (Misc queries) | |||
| Count the number of rows where more than one column meets set crit | Excel Worksheet Functions | |||
| i need 40 random numbers in 40 cell with no matches | Excel Worksheet Functions | |||
Linear Mode
