| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating sum based on value in adjacent column | Excel Discussion (Misc queries) | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| calculating adjacent columns in a work schedule | Excel Worksheet Functions | |||
| calculating adjacent columns in a work schedule | Excel Worksheet Functions | |||
| calculating adjacent columns in a work schedule | Excel Worksheet Functions | |||
Linear Mode
