| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating the totals of a group of cells based on content of oth
If:
A1= Chq B1= 100.00 A2= Sav B2= 200.00 A3=Visa B3= 50.00 A4=Chq B4= 75.00 B7= Total I am looking for I want the total in B7 to be: Where sum of A1:A4=chq the total sum of B1:B4 equals___ In this example the total in B7 should be $175.00 Anyone have any idea if this can be done and if so how and I'll love you for ever. -- Thanks Everyone Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
| Check cells content based on a table | Excel Discussion (Misc queries) | |||
| Macro to highlight cells based on content | Excel Worksheet Functions | |||
| Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
| Put an autoshape in a cell based on another cells content | Excel Worksheet Functions | |||
Threaded Mode
