how to find and add multiple entries
I have a matrix with two columns. The first column contains names while the
second contains values. I would like to sum all values that matche the string in the first column, so for example A B 1 Mike 200 2 Alex 100 3 Frank 110 4 Alex 180 and the matching string is Alex, the returning valus is 280 thanks |
how to find and add multiple entries
Try...
=SUMIF(A1:A4,"Alex",B1:B4) or =SUMIF(A1:A4,D1,B1:B4) ....where D1 contains your criterion, such as 'Alex'. Hope this helps! In article , "Marco" wrote: I have a matrix with two columns. The first column contains names while the second contains values. I would like to sum all values that matche the string in the first column, so for example A B 1 Mike 200 2 Alex 100 3 Frank 110 4 Alex 180 and the matching string is Alex, the returning valus is 280 thanks |
how to find and add multiple entries
Hi, Marco,
Try: =SUMPRODUCT(((A1:A4)="Alex")*(B1:B4)) Regards. -- JRod Microsoft MVP - Excel http://EXCELer.blogspot.com "Marco" escreveu na mensagem ... I have a matrix with two columns. The first column contains names while the second contains values. I would like to sum all values that matche the string in the first column, so for example A B 1 Mike 200 2 Alex 100 3 Frank 110 4 Alex 180 and the matching string is Alex, the returning valus is 280 thanks |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com