Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating totals in a column based on a lookup in another column
Hi all,
I am trying to do the following on the same worksheet: Calculate a total in one column based on an 'if' function from another column and return it in another cell. Can anyone suggest how I might do this - I have tried combining an 'if' statement with a 'sum' statement - I'm afraid that i cannot find the right syntax. Any advice gratefully received. Regards, Mike -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Hi
You were close! Have a look at the SUMIF function. -- Andy. "Michael Wright via OfficeKB.com" wrote in message ... Hi all, I am trying to do the following on the same worksheet: Calculate a total in one column based on an 'if' function from another column and return it in another cell. Can anyone suggest how I might do this - I have tried combining an 'if' statement with a 'sum' statement - I'm afraid that i cannot find the right syntax. Any advice gratefully received. Regards, Mike -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Calculating a field based on what is in another column | Excel Discussion (Misc queries) | |||
Totals based on dates | Excel Worksheet Functions | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |