Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells total help.
Hello Folks
Please can u help! On my worksheet call GFSA, in any the the cells C8 to C29 I have a name. It could be Big Rick in C8 only, or Big Rick in C8, C12, and C20. What is require is a formula in another sheet (called Calc) that will total the value from the corresponding Q column. Eg. GFSA sheet Cell C8="Big Rick" the give me the total from Q8 but if Big Rick is in cells c8,c12, and C20 then give me the total from Q8, Q12 and Q20. Hoping you can understand this logic. Your help is and always has been very much appreciated. Thanking you in anticipation. -- Big Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total of cells | Excel Discussion (Misc queries) | |||
The total of a couple cells and only include one of the cells if | Excel Discussion (Misc queries) | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
In several cells I have =?+423.55 I want total w/o the 423.55. | Excel Worksheet Functions | |||
SUMIF - Can I total the value of cells if three other cells = set | Excel Worksheet Functions |