I am trying to add one row if the another row is not 0. I am using the Aggregate function. Here is what I have and I'm getting a #VALUE! error.
=AGGREGATE(9,6,$K622:$DG622/($K258:$DG258<>0))
Also, what is the default [k] value for this function? I've tried default and using 1. Not quite clear on what [k] means...
Thanks!
Bookmarks