Sum with formula matriciale

[Maurizio]

Hi all,
I have this DB:

nr article
5 CARR PADOVA 48CR
9 CARR VENEZIA 12DL
3 CARR BOLOGNA 44E
13 UP CARR VENEZIA 48L
25 IR CARR PADOVA 25 R
2 CARR BOLOGNA 77U
1 ID CARR BOLOGNA 77R


How can I get with formula (matriciale) total?

TOTAL
6 BOLOGNA
22 VENEZIA
30 PADOVA


Tia.

 

[Aladin Akyurek]

Hi all,
I have this DB:

nr article
5 CARR PADOVA 48CR
9 CARR VENEZIA 12DL
3 CARR BOLOGNA 44E
13 UP CARR VENEZIA 48L
25 IR CARR PADOVA 25 R
2 CARR BOLOGNA 77U
1 ID CARR BOLOGNA 77R


How can I get with formula (matriciale) total?

TOTAL
6 BOLOGNA
22 VENEZIA
30 PADOVA


Tia.

Let A1:B8 house the data, the headers included.

Let E2:F4 house the prcosseing, with criteria in F2:F4.

E2:

1) control+shift+enter...

=SUM(IF(ISNUMBER(SEARCH(F2,$B$2:$B$8)),$A$2:$A$8)

2) alternatively, just enter...

=SUMPRODUCT(--ISNUMBER(SEARCH(F2,$B$2:$B$8)),$A$2:$A$8)

3) alternatively, just enter...

=SUMIF($B$2:$B$8,"*"&F2&"*",$A$2:$A$8)

The latter is the most efficient to have.

 

[Maurizio]

Simply perfect!
Thanks Aladin.

 

[Aladin Akyurek]

Simply perfect!
Thanks Aladin.

You are welcome. Thanks for the feedback Maurizio.