LinkBack URL
About LinkBacks
Hi Rosiel,
Here's a shorter way to write the basic formula:
While it doesn't deal with the "automatic detection", it would be easier to modify.
=(SUMPRODUCT(B10:B19/100,H10:H19)+B5)/B4
Cheers,
Hi Rosiel,
Here's a shorter way to write the basic formula:
While it doesn't deal with the "automatic detection", it would be easier to modify.=(SUMPRODUCT(B10:B19/100,H10:H19)+B5)/B4
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Many many thanks ConneXionLost for the quick response. I shall try this now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks