Suming a list

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
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index,match - how to avoid same lookup when duplicates present 1
adding multiple values from matched search results 3
SUMIFs across multiple sheets 7
SUMIFS, one criteria range, multiple criteria 2
custom data validation on cells with data validation values 2
Data Validation and drop-down list using IF, AND and what else? 8
Sum Product values meeting 2 criteria 2
SUM multiple criteria 1

Top