HOW TO Sum a dynamic range according to critieria

**shivpreet2k1** · 08-21-2009, 03:33 AM

Dear all is there any possiblity through which i can automate the sum of perticular cells.

for example the data is

DATE	           SCRIP	QUANTITY	RATE	VALUE
21.08.2009	   BHEL	 9               2       18
19.08.2009	   BHEL	-9              3      -27
20.08.2009	   FSL	          3             1        3
19.08.2009	   FSL	          2             4        8
22.08.2009	   BHEL	 9               5      45

I can enter data in new cells too but in the same columns. what i need is to sum the data appropriately like bhel sum should come automatedly

is there any way to do it.

tks

ShivPreet2k1

**DonkeyOte** · 08-21-2009, 04:05 AM

Your layout is not very clear - a file is generally preferable in these instances.

If we assumes Dates in Col A, Scrip in B, Qty in C, Rate in D & Value in E then to get a Sum of Value for BHEL:

=SUMIF(B:B,"BHEL",E:E)

**shivpreet2k1** · 08-21-2009, 05:17 AM

thanks for your help . its working. but friend can we make this fully automated. i mean what if i want to add new share for example bse1. is there any way to automate that too.

tks

Shiv Preet