Ask Your Question
1

Need help with a Calc formula [closed]

asked 2018-07-11 00:24:45 +0200

chowbok gravatar image

I have a Calc document with two sheets. I need it to take the value of cell Ax on Sheet2, total up the values in column B on Sheet1 where the corresponding value of the cell in column G equals that of cell Ax on Sheet2, and put that sum in cell Bx on Sheet2. Is this possible? Sorry if I'm not explaining this well.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-07-11 13:36:59.266918

1 Answer

Sort by » oldest newest most voted
2

answered 2018-07-11 01:14:19 +0200

erAck gravatar image

Assuming A2 for Ax and B2 for Bx, enter this formula into B2; also assuming row ranges 2 to 99 for columns, adapt as necessary.

=SUMIF($Sheet1.G$2:G$99;$Sheet2.A2;$Sheet1.B$2:B$99)

You can then copy&paste or pull down this formula cell to B3,B4,B5,... and the reference $Sheet2.A2 will be adjusted to $Sheet2.A3, $Sheet2.A4, $Sheet2.A5, ... while the other row references are absolute (prefixed with $) and stay the same.

edit flag offensive delete link more

Comments

Works great! Thanks so much!

chowbok gravatar imagechowbok ( 2018-07-11 02:47:15 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2018-07-11 00:24:45 +0200

Seen: 30 times

Last updated: Jul 11