Sum with conditions

[ze1l1]

Hi all
i need a formula like sumif but with more actions i will give u example of what i need to do

	A	B
1	S1	5
2	G1	10
3	G2	20
4	G3	30
5	Total	(the Sum Formula)

select range in which from the above formula cell to the brown B Cell
then to add the numbers in the column B which have G in the column A only
for example
set range 1 = Cells in column B from the above the formula cell to the brown colour cell
set range 2 = Cells in column A which is equivalent to the range 1
sum the numbers in range 1 which have value G in range 2
selecting the range must be automatically because it may vary i want the excel to understand the range FROM above the formula cell TO the brown colour what ever the number of cell inside it

[rajansettu]

Will you attach a sample worksheet..

[martindwilson]

what brown b cell?