Help needed in excel

[csKanna]

Hi,

help needed in excel

      ColA       ColB      ColC
1     Apple1     Jan       4562
2     Apple2     Jan       413
3     Apple3     Feb       12
4     Banana1    Jan       4654
5     Banana2    March     4562
6     Banana3    Jan       413
7     grape1     Jan       1432

I want to sum up data with region like Apple and month equal to jan
Ex: sum of all Apple like and jan = 4975

or is there any function avalaible that i can use instead of sumif?

thanks in advance.

Kanna

[csKanna]

I have a big list. I am not sure how can i achieve that using sumproduct().

Please help me on that.

[csKanna]

thanks. But I want to calculate the sum for all region starts with Apple.

[DKenny]

I would recommend using an Array Formula to do this

Copy this formula into any cell on your worksheet and rather than just pressing Enter, press Ctrl&Shift&Enter.
The formula should then show in the formula bar surrounded by curly brackets (note: manually typing in the '{'s will not work.

=SUM((C1:C7)*(B1:B7="Jan")*(LEFT(A1:A7,5)="Apple"))

I have attached an example

[DKenny]

This piece of the code looks for all instances of apple, regardless of any suffix.

LEFT(A1:A7,5)="Apple"