• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Alternative to SUMPRODUCT for Documents to Go

    Thank you so much for the tip! I reworked the formula and it worked! =SUMIF(I4:I500,">="&(D2-(7*E2-1)),O4:O500)-SUMIF(I4:I500,">="&D2,O4:O500) Now I have to convert all the SUMPRODUCTS to SUMIF then I will test it on my mobile devices! Thanks again to Chandoo and friends!
  2. M

    Alternative to SUMPRODUCT for Documents to Go

    Here is the link to the sample.xls https://www.box.com/s/tnclny4wg5bxhy2j1944
  3. M

    Alternative to SUMPRODUCT for Documents to Go

    I have a SUMPRODUCT formula that isn't compatible with Documents to Go on my mobile devices. I have tried rewriting with SUMIF but I keep getting stuck on entering a cell reference into SUMIF. Maybe SUMIF can't take a cell reference with operands? Here is the formula that I'm trying to...
Back
Top