Help needed in excel

Hi,

help needed in excel

Code:

---

      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

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

Please help me on that.

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

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.

Code:

---

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

---

I have attached an example

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

Code:

---

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

---