Sum of values based on variable values

[PRADEEPSWALSE]

Hi,
I need help for addition of variable values.
E.g. Values in column 'B' are variable. I want SUM of values mentioned in column 'C' based on values of column 'B'. I have total 10 rows. Values of column 'B' are variable and it will be entered by user. Some cell may be empty. Refer attached Images for easy understanding.

Please suggest solution for this query.
Thanks in advance.

Regards,
Pradeep

 

[mohadin]

Hi
Try the formula

C23=SUMIF($B$2:$C$11,B23,$C$2:$C$11)

 

[jasonb75]

Based on the screen capture,

Book1
	B	C
22	Thq	Qty
23	25	10
24	50	13
25	75	5
26
27
28
29
30
31
32
33
Sheet2

Cell Formulas
Range	Formula
B23:B33	B23	=IF(B22="","",IFERROR(AGGREGATE(15,6,$B$8:$B$18,1+COUNTIF($B$8:$B$18,"<="&N(B22))),""))
C23:C33	C23	=IF(B23="","",SUMIF($B$8:$B$18,B23,$C$8:$C$18))

 

[PRADEEPSWALSE]

Hi,
I need help for addition of variable values.
E.g. Values in column 'B' are variable. I want SUM of values mentioned in column 'C' based on values of column 'B'. I have total 10 rows. Values of column 'B' are variable and it will be entered by user. Some cell may be empty. Refer attached Images for easy understanding.

Please suggest solution for this query.
Thanks in advance.

Regards,
Pradeep

Hi
Try the formula

C23=SUMIF($B$2:$C$11,B23,$C$2:$C$11)

Hi,

Thanks for the reply. But my requirement is little bit different.

 

[PRADEEPSWALSE]

Based on the screen capture,

Book1
	B	C
22	Thq	Qty
23	25	10
24	50	13
25	75	5
26
27
28
29
30
31
32
33
Sheet2

Cell Formulas
Range	Formula
B23:B33	B23	=IF(B22="","",IFERROR(AGGREGATE(15,6,$B$8:$B$18,1+COUNTIF($B$8:$B$18,"<="&N(B22))),""))
C23:C33	C23	=IF(B23="","",SUMIF($B$8:$B$18,B23,$C$8:$C$18))

Hi,

Thanks for the reply.
It works very nicely and my problem is resolved. Thank you.

 

[PRADEEPSWALSE]

Hi,

Thanks for the reply. But my requirement is little bit different.

Hi,
Again I need help in addition depends on two variable values. i.e. pipe size and thk. Quantity to be calculated based on pipe size and thk. Please refer OUTPUT SHEET for your ready reference.

Values of column 'B' and 'C'are variable and it will be entered by user. Some cell may be empty.
Please suggest solution for this query.
Thanks in advance.


Regards,
Pradeep

 

[jasonb75]

Are you still using excel 2013, or have you upgraded since you set up your profile? This will be much easier if you have the UNIQUE function from office 365.

Also, are the pipe sizes in column B formatted numbers, or text strings? This can be tested with the formula

=COUNT(B5:B19)

If the pipe sizes are formatted numbers then this will count them, if they are text it will not count anything.

 

[PRADEEPSWALSE]

Are you still using excel 2013, or have you upgraded since you set up your profile? This will be much easier if you have the UNIQUE function from office 365.

Also, are the pipe sizes in column B formatted numbers, or text strings? This can be tested with the formula

=COUNT(B5:B19)

If the pipe sizes are formatted numbers then this will count them, if they are text it will not count anything.

Hi,

Thanks for reply.
Yes... I am using excel 2013.

I can please elaborate the solution provided by you. I have not understood.

 

[jasonb75]

It wasn't a solution, it was a question! The purpose of the formula is to identify the format of your pipe sizes.

If you use that formula with the sample from post 6 it should either return 10 or 0

 

[PRADEEPSWALSE]

It wasn't a solution, it was a question! The purpose of the formula is to identify the format of your pipe sizes.

If you use that formula with the sample from post 6 it should either return 10 or 0

Okay.
Pipe size column (B5:B19) return to zero.