SUMIF help!

[louncov]

G'day,

I'm familiar with the SUMIF calculation...

A B
1 Peaches 5
2 Pears 10
3 Apples 15
4 Oranges 20
5 Bananas 25

SUMIF(A1:A5,A1,B1:B5) would give me '5', as would
SUMIF(A1:A5,"Peaches",B1:B5). My problem is if I want to know
'Peaches' & 'Pears', something like...

SUMIF(A1:A5,"Pea*",B1:B5)

I know this wouldn't work, as it would search for Pea*, but you get
the idea. I'd be looking for a '15'. Text string variables?

Thanks to all,
Cov.

 

[Alan Beban]

Here's a thought--try

SUMIF(A1:A5,"Pea*",B1:B5)

Alan Beban

 

[Ken Wright]

rotflmao.......... and then some........ <vbg>

 

[Leo Heuser]

Or

=SUMPRODUCT((A1:A5={"pears","peaches"})*(B1:B5))

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Ken Wright]

And just to be different:-

=SUMPRODUCT((LEFT(A1:A5,3)="pea")*(B1:B5))

 

[Andy B]

Leo

That doesn't work for me!! (XL2K)

Andy

Or

=SUMPRODUCT((A1:A5={"pears","peaches"})*(B1:B5))

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Andy B]

OH, YES IT DOES!!! Missed the curly brackets!!

Cheers
Andy

 

[louncov]

OH, YES IT DOES!!! Missed the curly brackets!!

Cheers
Andy

Beauty! Thanks to all.