ExcelBanter - sumif problems

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumif problems (https://www.excelbanter.com/excel-discussion-misc-queries/124935-sumif-problems.html)

Ricardo

sumif problems

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.

Teethless mama

sumif problems

=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.

Ricardo

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.

All times are GMT +1. The time now is 12:35 AM.