Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct/SumIf
Would appreciate help with the following: Sum column B where name in A:A =
A1 and B:B < 10. Result for John should be 9. Once formula points to Mark, his total should be 14. Tried SumProduct, but I'm only getting the count of rows that meet criteria, not the sum. A B John 10 John 09 Mark 3 Mark 4 Mark 7 Many thanks! -- T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct and sumif | Excel Worksheet Functions | |||
SUMIF OR SUMPRODUCT?? | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SumIf or SumProduct | Excel Worksheet Functions | |||
SUMPRODUCT or SUMIF | Excel Discussion (Misc queries) |