LinkBack URL
About LinkBacks
G'day Folks
I have many Workbooks where Sheet1! Col H have individual values on many rows.
I want to divide 1 by each value individually and return the SUM of those new values to Sheet2! Cell H1.
Sample Workbook attached.
Thankum
G'day Folks
I have many Workbooks where Sheet1! Col H have individual values on many rows.
I want to divide 1 by each value individually and return the SUM of those new values to Sheet2! Cell H1.
Sample Workbook attached.
Thankum
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
Formula:
Please Login or Register to view this content.
BSB
Thanks BSB..could you point the formula to sheet 1 for me thanks.
Formula:Please Login or Register to view this content.
BSB
Okay, we are wearing it down now
One more thing with it....
Say I wanted to use a set range in the formula eg H2:H2000 but some of the cells in that range will be blank...can we make that work?
Perhaps something like...
Formula:Please Login or Register to view this content.
BSB
Try:
=SUM(IFERROR(1/Sheet1!H2:H2000,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Quang PT
Champions one and all!
Both solutions work!
Thanks to you both.
Cheers
hammer
Happy to help.
Thanks for the rep point
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks