Sumif to left

[chintan.cwa@rediffmail.com]

I have the date as follow:


Amount Area

10 A

20 C

30 F

22 A

45 A

I can use the formule sumif , if the the column "area" is before the "amount".


Kinldy suggest the formule to sum of this.

 

[kaushik03]

Hello Chintan,


Welcome to chandoo.org forum and we glad to have you here.


I do not understand you your requirement clearly.


It does not matter which side the area column is when you run the sumif formula.


Say your data is as follows from Col A to Col C:

[pre]

10	A	10
20	C	20
30	F	30
22	A	22
45	A	45

[/pre]

Sumif formula when area is before the amount:


=SUMIF(B1:B5,"A",C1:C5) enter...will give you 77


Sumif formula when area is after the amount(which is your concern I believe):


=SUMIF(B1:B5,"A",A1:A5) enter...will give you 77


So, both the cases you will get the same answer no matter which side your criteria range / sum range is located.


Are you trying to do any lookup to left side? If yes, then INDEX-MATCH or VLOOKUP-CHOOSE functions can be used.


Request you to plz post back in case of any further help is required.


Regards,

Kaushik

 

[chintan.cwa@rediffmail.com]

thank you very much kaushik03.

 

[kaushik03]

You are welcome..