sumif problems
thanks for help
"Teethless mama" escreveu:
=SUMPRODUCT(--(A1:A100="John"),--(B1:B1005),B1:B100)
"Ricardo" wrote:
hi
i have a problem with the sumif. i have the following example
Col. A Col. B
John 5
Joe 10
John 6
John 7
I want to know the sum of John´s I have 5
Thanks for help. Have a great 2007.
|