Excel Summarization of indexed column

Joined
Feb 24, 2017
Messages
1
Reaction score
0
Hi guys!

I have some sheet like this one:
brkuk8tak4rg76d8vwpdfewd4byw7ka8.JPG


As you can see, by changing number in column A1 is also changing calculation in E5.
Is there any possibility, how to summarize all 3 calculations while E5 still indexed?
I can't just copy+paste characters and then SUM() or make function, my original calculation is in a huge file with many sheets.Unfortunately, I can't use VBA.

Many thanks!
Gateux
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
I think I'm probably missing something here... is there a reason you can't simply do (B5*C5)+(B6*C6)+(B7*C7)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top