Simple Problem

[jr4578]

Hey,

Brand new to the forum and just trying to work out a budgeting problem.

Basically, I have (C4*B4) in C2. it works, obviously. But, in the same cell I want to add (C5*B5) + (c6*b6) etc etc all the way until (c85*b85). and then I need it to translate into D column. And henceforth until column AT (i.e. (AT4*b4), and then down to (AT85*B85))

I feel like there is a simple solution, but I've been working at it all day and cannot seem to find a proper way to do so, and have become more than frustrated numerous times. I can, of course, do it manually, but repeating this in 52 columns is going to drive me insane.

Sorry if I haven't explained well; again, I'm a little exasperated haha

 

[Fennek]

Hello,

at the moment I have no possibility to test it, therefore only an idea:

C2: =sumproduct(C4:C85, B4:B85)

regards

 

[jr4578]

Thank you for the response, however still no luck

Kindest,
JR

 

[StephenCrump]

Fennek's Sumproduct suggestion should work just fine. Here's a cut down example:

C2: =SUMPRODUCT($B4:$B6,C4:C6) Copy formula to the right

Book1
	A	B	C	D	E	F
1
2	TOTALS		8.5	19	3.5	23
3
4		0.50	1	4	1	2
5		1.00	2	5	1	2
6		2.00	3	6	1	10
Sheet1

 

[jr4578]

For some reason, I cannot get this formula to work, even with copy/paste.

I am using OpenOffice/Google Sheets, which is probably the reason. Any advice on how to translate it into these platforms?

 

[StephenCrump]

It should work exactly the same in Google Sheets. When you say that you can't get it to work, what exactly is happening? Are you getting error values, or perhaps incorrect results? In all columns?

When you say OpenOffice (and refer to platforms), do you mean that you're also using OpenOffice Calc?

 

[jr4578]

It tells me there's a formula parse error.

I use Google sheets mainly (because I like having access on my phone as well), but sometimes I'll use the open source "Excel" that Open Office has as a test run when I don't have internet.

In both (Google and Open Office) I get the same "Formula Parse Error"

 

[StephenCrump]

Sumproduct works fine for me in Google Sheets.

Did you try the example exactly as given?

If you modified the formula for your layout, can you please copy/paste the exact formula that you're trying to use?