G
Guest
I have a spreadsheet with values in f25,f32,f39....b25, b32,b39. I want to
evaluate the sumproduct of these two arrays. I have tried
sumproduct((f25,f32,f39),(b25,b32,b39)) and it returns the #VALUE! error. I
have tried naming these ranges and various other syntax, but I have had no
luck. Can you calculate a sum product on non-adjacent cells?
evaluate the sumproduct of these two arrays. I have tried
sumproduct((f25,f32,f39),(b25,b32,b39)) and it returns the #VALUE! error. I
have tried naming these ranges and various other syntax, but I have had no
luck. Can you calculate a sum product on non-adjacent cells?