Sum value col3 based on value of col1 and col2 for Google Sheets

[new1]

I have three columns in which I want sum value of col3 based on col1 and col2 value
if col1 = 1 and col2 = 40
then sum all value of col3
but if col1 = 1 and col2 = 20 or
col1 = 2 and col2 = 40
then sum col3 value according to the col1 and col2 value
for this purpose I am sharing the link of google sheet with dummy data set please check and give me your suggestion or help.
Thank you.Shared google sheet

 

[hrayani]

Is this what you are asking for ??

TEST FILE.xlsm
	A	B	C	D
1	col 1	col 2	col 3
2	1	40	400	1600
3	1	40	400
4	1	40	400
5	1	40	400
6	1	20	200	400
7	1	20	200
8	2	40	400	1200
9	2	40	400
10	2	40	400
11	2	25	250	250
Sheet6

Cell Formulas
Range	Formula
D2:D11	D2	=IF(AND(A2=A1,B2=B1),"",IF(AND(A2=1,B2=40),SUMIFS($C$2:$C$11,$A$2:$A$11,1,$B$2:$B$11,40),IF(AND(A2=1,B2=20),SUMIFS($C$2:$C$11,$A$2:$A$11,1,$B$2:$B$11,20),IF(AND(A2=2,B2=40),SUMIFS($C$2:$C$11,$A$2:$A$11,2,$B$2:$B$11,40),C2))))

 

[new1]

Is this what you are asking for ??

TEST FILE.xlsm
	A	B	C	D
1	col 1	col 2	col 3
2	1	40	400	1600
3	1	40	400
4	1	40	400
5	1	40	400
6	1	20	200	400
7	1	20	200
8	2	40	400	1200
9	2	40	400
10	2	40	400
11	2	25	250	250
Sheet6

Cell Formulas
Range	Formula
D2:D11	D2	=IF(AND(A2=A1,B2=B1),"",IF(AND(A2=1,B2=40),SUMIFS($C$2:$C$11,$A$2:$A$11,1,$B$2:$B$11,40),IF(AND(A2=1,B2=20),SUMIFS($C$2:$C$11,$A$2:$A$11,1,$B$2:$B$11,20),IF(AND(A2=2,B2=40),SUMIFS($C$2:$C$11,$A$2:$A$11,2,$B$2:$B$11,40),C2))))

Thank you buddy for your reply but i was searching for a dynamic formula like arrayformula using which i used one cell and it should apply on complete row and if you are asking that i want solution in this way then yes i want solution like this only and also i have also used pivot table to get data like this and then used GETPIVOTDATA function to get the sum value but I don't want this because it makes google sheet slow so I am searching for the formula which can solve this problem

 

[Fluff]

@new1 when you want something for Google Sheets, you should clearly state that in you original post & all such questions should be posted to the General Discussion & Other Applications section of the board

I have moved it for you & amended the thread title, this time.

 

[new1]

okk so, for which purpose this thread option is given?

 

[Fluff]

Sorry, but I don't understand what you are asking.

 

[new1]

actually I am asking that, you were saying the type of question i asked should be posted in general discussion & other application section, so I am asking why is their a option of creating of new thread in this website.

 

[Fluff]

You can start a new thread in any part of the site, but it's split into different sections. As you are asking about a formula for Google Sheets you need to post it into the general discussion & other application section because that is where it belongs

This forum is for discussion about any application & for questions about applications other than Excel or Access.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.