| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Sumif formula
Can you help me with the following sytuation
I have data in sheet1 in a vertical order Sheet1 A B C D data Info1 Info2 Info3 information 55 5 -1 information -5 -9 2 In sheet2 I need to sum values that are less than 0 Sheet2 Info1 =SUMIF(B3:B5,"<0",B3:B5) Info2 =SUMIF(c3:c5,"<0",c3:c5) Info3 The problem is that I don't want to change manually range of each one category I need a range to be more flexable. Is it possible to do it? Thanks Eva |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
| Advanced formula/inserting text question | Excel Worksheet Functions | |||
| Advanced Filter criteria (formula) | Excel Worksheet Functions | |||
| Advanced Formula... | Excel Discussion (Misc queries) | |||
Threaded Mode
