Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Arrays
I was playing around with these two functions...
=SUM((A1:A10)*(MOD(ROW(A1:A10),2))) =SUMPRODUCT(A1:A10,MOD(ROW(A1:A10),2)) The first formula being an array function (you have to press ctrl+shift+enter). With both of these functions I have to use a specified range, I can't use the whole colum A:A. Why is this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Cumulative Summing | Excel Discussion (Misc queries) |