Ok I have the following basic formula which applies to one row
=($E9/$D9)*$K9
What I need to do is somehow make this an array formula such that it performs this calculation on lets say EACH row from 9 to 20 and adds up all the results.
Im pretty sure a sum and some sort of array formula will do it, I just never understand these array formulas :P
No need for array formulas. Try:
=SUMPRODUCT(E9:E20/D9:D20*K9:K20)
Although this will cause an error if any of the cells in D9:D20 are blank or 0.
HTH
Jason
thanks.
There will be blanks in D9-D20 as there are blank lines on the spreadsheet, I think there will also be cases where there is something in D and not in K, I guess ideally it would only perform the calculation on the row when all 3 values are >0.
Is there any way to do this? if the 3 cells are not>0 then go on to the next row instead
Last edited by neowok; 04-02-2008 at 04:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks