If Formula taking info from another work sheet multiple collumns

[SoullessToaster]

Hi Mr Excel Users!

Please be my saviours!
I am writing an income and expenditure spread sheet
I am wanting to write a formula to do the following thing:
(im personally looking at IF statements, but if you can think of a better way of doing it, im all ears.)

To analyse an entire column for a particular word- for example "Rent" (column F)
If that word comes up, i want it to take the figure from the cell in the G column of that row.

I want it to add them all up to give a total, therefore giving a total spending on rent as the spreadsheet goes along.

This will enable me to keep track of spending on different items and make accounting easier.


If you need more information, just ask...

Kind regards

Toaster

 

[Shiremaid]

It sounds to me like you need a SUMIF

=SUMIF(F:F,"Rent",G:G)

So that would look in Column F for the word 'Rent' and add up any Numbers for the corresponding cell in Column G

 

[SoullessToaster]

THANK YOU!
That is amazing!