If statement for a total of a different column

[Cole Parker]

Hi,
I am trying to build a template and use excel to pull totals over for me so i dont have to manually do this everytime..
I want to check column C for a certain text value on another sheet and if it containts the certain text, i want it to pull the dollar figure from the column next to it. (D)
then sum the entire amount.


Thank you!
I cant make it work in my head

 

[Sufiyan97]

Hii, Welcome to Mr.Excel

Do you want something like this?

Sheet1

Book1
	C	D
1	Description	Amount
2	Text1	1
3	Text1	1
4	Text1	1
5	Text2	2
6	Text3	3
7	Text3	3
8	Text3	3
9	Text2	2
Sheet1

Sheet2

Book1
	A	B	C
1	Description	Amount
2	Text1	3
3
4
5
Sheet2

Cell Formulas
Range	Formula
B2	B2	=SUMIF(Sheet1!C:C,Sheet2!A2,Sheet1!D:D)

 

[Cole Parker]

Hii, Welcome to Mr.Excel

Do you want something like this?

Sheet1

Book1
	C	D
1	Description	Amount
2	Text1	1
3	Text1	1
4	Text1	1
5	Text2	2
6	Text3	3
7	Text3	3
8	Text3	3
9	Text2	2
Sheet1

Sheet2

Book1
	A	B	C
1	Description	Amount
2	Text1	3
3
4
5
Sheet2

Cell Formulas
Range	Formula
B2	B2	=SUMIF(Sheet1!C:C,Sheet2!A2,Sheet1!D:D)

This is what i ended up with

=SUMIF('30 Days'!C:C,"1A1-CONSTRUCTION-RESIDENTIAL PROPERTY",'30 Days'!D:D)

this took the text value from the '30 days' sheet and looked through column c for "1A1-CONSTRUCTION-RESIDENTIAL PROPERTY", then should take the dollar amounts from the D column.

Am i correct in that?

Thank you for the quick reply.

 

[Sufiyan97]

This is what i ended up with

=SUMIF('30 Days'!C:C,"1A1-CONSTRUCTION-RESIDENTIAL PROPERTY",'30 Days'!D:D)

this took the text value from the '30 days' sheet and looked through column c for "1A1-CONSTRUCTION-RESIDENTIAL PROPERTY", then should take the dollar amounts from the D column.

Am i correct in that?

Thank you for the quick reply.

Yes,

You're correct.

 

[Cole Parker]

Yes,

You're correct.

Thank you for your help!!

 

[Sufiyan97]

You're welcome!