Formula to Auto sum from Table

  • Thread starter Thread starter Legacy 185509
  • Start date Start date
L

Legacy 185509

Guest
Hi
This is my data which I need to add
it goes like this
I need to generate table on side of this table which will automatically add
all A0 example
will add 20.94+67.03+23.75 into one cell
will add 655.20+18648+4347 into other cell
will average 1,.96 & .98
It would've been easy it A0,A4,B2,B3 were same number of rows but they differ everytime
please show me easiest way to do this
this data is timed that why I need to redo this for lots of different timings

image removed, sensitive information
 
Last edited by a moderator:

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
You can use SUMPRODUCT.

=SUMPRODUCT((A1:A26="AO")*(D1:D26))

Adapt that for the other sums you need.
 
Upvote 0
Hey thanks for reply but that formula is not showing any number it shows "VALUE"
 
Upvote 0
Hey thanks alot for hint that helped me alot, I figured it out :)
"Hey thanks for reply but that formula is not showing any number it shows "VALUE""

but I just need 1 bit of help
I want to write a formula which will compare first column
if they are same skip one like

I need to write one of A0, one of A4, one of B2 and so on....

I want to do it by formula
if A2=A3, check for A4, if it is still equal to A2, check A5, if A5 not equal to A2 set this cell to A5
 
Last edited by a moderator:
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top