Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2003
I have a spredsheet as follows: Col A = number of people related to each entry.(either 1 or 2) Col B = Peoples names.(either single or a couple.) Col. i = Balance paid. Cell i97 = total paid to date. Col.A Col.B Col. i 2 Us 2 £10 1 Me £5 Cell i 97= 2 Now what I am trying to create is CELL i97 to give me the number that have paid to date as I update Col. B. What I have at present in Cell i97 is just a sum total of entries. In example above Cell i97 = 2 but I want it to = 3 as totalling Col A would give me, as a number....Col i relates to Col.A Hope I have explained ok? TIA Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF Not | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |