| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ms works question
What I am trying to do is, from row 9 thru 900 find all values in column
"A" that are equal to 1 or 1.5, and in those rows sum the values of column "O" and put this total in cell A3. This is what I have tried unsuccessfully =vlookup("1",A9:A900,sum(O9:O900) please help me if at all possible. thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ms works question
In excel, there's an =sumif() function.
=sumif(a9:a900,1,o9:o900) I don't know if that exists in Works, though. Gary wrote: What I am trying to do is, from row 9 thru 900 find all values in column "A" that are equal to 1 or 1.5, and in those rows sum the values of column "O" and put this total in cell A3. This is what I have tried unsuccessfully =vlookup("1",A9:A900,sum(O9:O900) please help me if at all possible. thank you -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting from works database | Excel Discussion (Misc queries) | |||
| Inport of Microsoft Works Spreadsheets | Excel Discussion (Misc queries) | |||
| convert works 4.5 spreadsheet to Excel 2002 (Office xp) | Excel Discussion (Misc queries) | |||
| DIFFERNCE BETWEEN EXCELL AND WORKS SPREEDSHEETS | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Linear Mode
