# sum different column

1. ### Grand Total by type of column

Hello, I have the following tables: table name: Concentrado table name: Empresa table name: Moneda The "Concentrado" table accumulates all the operations, the "Moneda" table indicates all the currencies in which operations can be carried out, the "Compañia" table indicates all the...
2. ### Sum on Left lookup up.

Everytime I come to crate a formula that uses a left lookup I end up looking for answers on various forums. Today, however, I cannot find the answer, so need to ask here. I have a spreadsheet with names of Towns (Ipswich, Newmarket, etc) in Column R and a quantity figure in Column E...
3. ### Auto-calculate 2 column that contains numbers and words words

Hi everyone, I've been using conventional method to do this and it's time consuming. I would like to total up 2 column. A multiply B to be exact. Below are some examples: Table 1 - Before totaling up: <table dir="ltr" border="1" bordercolor="#05ad00" cellpadding="2" cellspacing="1"...
4. ### Formula - only SUM based on criteria

Hi all ex(cel)perts, I am looking for a formula that would sum all cells that meet a specific criterion in a different cell. To Illustrate: I have NAMES of individuals in column C and TOTALs in columns E. I am hoping there is a way were XL automatically finds the name and the appropriate...

### 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.

### Which adblocker are you using?

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

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