Sum of a column which contains text and commas(,)

[abmati]

Hi Friends, after a long time I put a post as I stuck with a complex formula. Please help me out.
How to do sum of a column which have "INR" in the begging and there are comms(,) in the numeric value?
I tried this
=SUM(IF(E4:E1000,LEFT(E4:E1000,3)="INR",NUMBERVALUE(MID(E3:E1000,5,11))))
but it does not work. My data are in column E, as given below

INR 7,72,813.00

INR 8,27,073.00

INR 5,00,378.00

Please suggest me your expert advice.
Thanks and Regards.

 

[Anonymous1378]

Try removing the mistakes from your formula?

Book1
	E	F
4	INR 7,72,813.00	2100264
5	INR 8,27,073.00
6	INR 5,00,378.00
Sheet1

Cell Formulas
Range	Formula
F4	F4	=SUM(IF(LEFT(E3:E10,3)="INR",NUMBERVALUE(MID(E3:E10,5,11))))

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)