samedi 5 novembre 2016

How do I sum up the numbers from a column when the row contains a specific text

I have a question about Excel. enter image description here

I need to make a formula and it has to be like this; if a cell contains a specific text, it has to sum up numbers from a specific column in that same row.

For example; if column D contains 'Crewe', sum up the numbers from column H

Aucun commentaire:

Enregistrer un commentaire