A B
1 500 L-Truck
2 200 L-Car
3 150 T-Car
4 100 T-Truck
5 400 T-Truck

Using Sumif, is it possible to sum up only Car & Only Truck

I would like to see a total for Car as 350 & Truck 1000

=SUMIF(B1:B5,"??Truck",A1:A5)

HTH
--
AP

"Ananth" a écrit dans le message de news:
...
A B
1 500 L-Truck
2 200 L-Car
3 150 T-Car
4 100 T-Truck
5 400 T-Truck

Using Sumif, is it possible to sum up only Car & Only Truck

I would like to see a total for Car as 350 & Truck 1000

One way is to use SUMPRODUCT ..

Assume data in cols A and B, from row2 to row10 (say)

Enter
In D2: Car
In D3: Truck

Then place in E2:
=SUMPRODUCT(--ISNUMBER(SEARCH(D2,$B$2:$B$10)),$A$2:$A$10)
Copy E2 down

Adapt the ranges to suit, but note that we can't use entire col references
in SUMPRODUCT, unlike SUMIF
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ananth" wrote:
A B
1 500 L-Truck
2 200 L-Car
3 150 T-Car
4 100 T-Truck
5 400 T-Truck

Using Sumif, is it possible to sum up only Car & Only Truck

I would like to see a total for Car as 350 & Truck 1000

Thanks very much.

"Ardus Petus" wrote:

=SUMIF(B1:B5,"??Truck",A1:A5)

HTH
--
AP

"Ananth" a écrit dans le message de news:
...
A B
1 500 L-Truck
2 200 L-Car
3 150 T-Car
4 100 T-Truck
5 400 T-Truck

Using Sumif, is it possible to sum up only Car & Only Truck

I would like to see a total for Car as 350 & Truck 1000