-
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
-
Re: Help needed in excel
I have a big list. I am not sure how can i achieve that using sumproduct().
Please help me on that.
-
Re: Help needed in excel
thanks. But I want to calculate the sum for all region starts with Apple.
-
1 Attachment(s)
Re: Help needed in excel
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
-
Re: Help needed in excel
This piece of the code looks for all instances of apple, regardless of any suffix.
Code:
LEFT(A1:A7,5)="Apple"