| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF of specified cells in a range
I have a column of data that i want to use SUMIF0 but its not over the whole
range, just every 5th row for instance... a1=5 a6=8 a11=-5 a16=2 a21=-22 SUMIF only seems to work with a continuous array of cells not targetted cells, any ideas how to get around this? (I just need to sum the non negative figures) something like SUMIF(a1,a6,a11,a16,a21)0 or something like that... Thanks Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif between a range | Excel Discussion (Misc queries) | |||
| SumIf and a Range of Cells | Excel Discussion (Misc queries) | |||
| sumif() using range name | Excel Worksheet Functions | |||
| How to use a range in SUMIF? | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
