Thread
:
Sumproduct/SumIf
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Sumproduct/SumIf
try
=sumproduct((a2:a22=a1)*(b2:b22<10)*b2:b22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"T" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett