| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort and sum data range with some blank cells
Column A and B of Sheet1 has the following data entered:
Sheet1 A1=Joe , B1=5 Sheet1 A2=Joe , B2=5 Sheet1 A3=Pat , B3=2 Sheet1 A4=Joe , B4=5 Sheet1 A5 and B5 is blank Sheet1 A6 and B6 is blank Sheet1 A7 and B7 is blank I want to be able to enter the name "Joe" in Sheet5 A2 so that the sum of 15 shows in cell C2 of Sheet5. I need it to work so that if Joe is later entered in Sheet1 A5 and the number 5 is also entered in Sheet1 B5, Sheet5 C2 changes to the new sum of 20. How can I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sort and sum data range with some blank cells
Enter this formula in Sheet5 cell C2:
=SUMIF(Sheet1!A:A,A2,Sheet1!B:B) -- Biff Microsoft Excel MVP "rldjda" wrote in message ... Column A and B of Sheet1 has the following data entered: Sheet1 A1=Joe , B1=5 Sheet1 A2=Joe , B2=5 Sheet1 A3=Pat , B3=2 Sheet1 A4=Joe , B4=5 Sheet1 A5 and B5 is blank Sheet1 A6 and B6 is blank Sheet1 A7 and B7 is blank I want to be able to enter the name "Joe" in Sheet5 A2 so that the sum of 15 shows in cell C2 of Sheet5. I need it to work so that if Joe is later entered in Sheet1 A5 and the number 5 is also entered in Sheet1 B5, Sheet5 C2 changes to the new sum of 20. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking to a data range containing blank cells | Charts and Charting in Excel | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Why arent my blank cells moved to the end when I do a sort? | New Users to Excel | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Hybrid Mode
