Calculating sum of adjacent cell
 

Hi

I need to find all the cells adjacent to a text value and calculate the
total on a seperate sheet.

Similar to below

NG £250
LW £150
NG £370
KW £450

Total NG £620
Total LW £150

etc.

Ideas?

Calculating sum of adjacent cell
 

=SUMIF(Sheet1!A:A,"NG",Sheet1!B:B)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danno 24/7" <Danno wrote in message
...
Hi

I need to find all the cells adjacent to a text value and calculate the
total on a seperate sheet.

Similar to below

NG £250
LW £150
NG £370
KW £450

Total NG £620
Total LW £150

etc.

Ideas?

Calculating sum of adjacent cell
 

Thanks Bob

"Bob Phillips" wrote:

=SUMIF(Sheet1!A:A,"NG",Sheet1!B:B)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danno 24/7" <Danno wrote in message
...
Hi

I need to find all the cells adjacent to a text value and calculate the
total on a seperate sheet.

Similar to below

NG £250
LW £150
NG £370
KW £450

Total NG £620
Total LW £150

etc.

Ideas?