Is there a way to do a sumproduct of every item in a range with 1?
=SUMPRODUCT(A1:A5,{1,1,1,1,1}) does not work for whatever reason. Neither does =SUMPRODUCT(A1:A5,1). Any way to do this without a helper column? Thanks
Is there a way to do a sumproduct of every item in a range with 1?
=SUMPRODUCT(A1:A5,{1,1,1,1,1}) does not work for whatever reason. Neither does =SUMPRODUCT(A1:A5,1). Any way to do this without a helper column? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks