LinkBack URL
About LinkBacks
I am getting a result of 0.2 from a formula in cell AG10, even though it involves multiplication with blank cells (G10:Q10). I would be grateful if anyone could help me find where the issue might be from.
problem Excel.JPG
I am getting a result of 0.2 from a formula in cell AG10, even though it involves multiplication with blank cells (G10:Q10). I would be grateful if anyone could help me find where the issue might be from.
problem Excel.JPG
Hi
please see yellow banner for how to post a sheet
Are you sure that those row 10 cell are blank, maybe a formula, or a number with CF or numberformat hiding them.
BTW, you can use SUMPRODUCT to simplify your formula
=SUMPRODUCT(G7:Q7,G10:Q10)
The formula you provided surprisingly works!!
Strange how the one I entered was having issues with the blank cell.
Thanks.
Last edited by AliGW; 05-10-2020 at 11:10 AM. Reason: Please don't quote unnecessarily!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In my test, your formula also worked. There must be something there.Originally Posted by Bhavishize
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks