summarise columns

  1. G

    Multiplies and SUMMARIZE columns

    Hi, I'd like to multiply the values in column C by those in column E and display the sum in cell F2 without creating an additional column for the intermediate results. Is there a solution for this problem?
  2. S

    creating a summary table

    hey guys i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above...
  3. G

    Summary non numeric data

    Hi Community, I´m working on a summary sheet (by date and within a time span (between 2 dates)) and all fine with numeric values, but i can´t figure out how to aproach the columns with cells/columns containing text. For some columns i have to get all disctinct values in one cell for a given...
  4. G

    Copy Text in a Range of Rows with blanks in between to a list of rows with no gaps.

    So I want to summarize data from one sheet to another. I would like this: A B 1 John John 2 Bill 3 Tom 4 Bill Peter 6 Rob 7 8 Tom 9 Peter 10 11 Rob I found some solutions using an IFERROR command which do not...
  5. N

    hlookup summarise multiple columns - HELP

    Hi, I am trying to automise effort calculations for a project by phase (the columns in the spreadsheet hold days per week per resource type). As the phase can vary in time, I've created a header which indicates the phase. I need "something" :) to look up the header to determine which phase and...

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