Suming a list

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

I want to create an equation that sums a column but only when on
column's text matches another.

Eg

Column A
A
A
B

Column B
1
3
66

Only when A appears in Column A, the Totals in Column B need to b
added up. Any Ideas?

I think it should start off like:-

=SUMPRODUCT((A1:A3=A)*(SUMI1:I9))
or something like this. Much appreciate the help
 
You are very close. Use something like

=SUMPRODUCT((A1:A10="A")*B1:B10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top