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