• 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. O

    Sumif with critera between a range

    Brilliant, just needed to put " " around to change it to text other than that thank you so much =SUMPRODUCT((A24:A27>="500")*(A24:A27<"600"),B24:B27)
  2. O

    Sumif with critera between a range

    I did orginally have a helper columns, unfortunately i have to do more than just the one range, so i ended up with loads of helper columns Cheers
  3. O

    Sumif with critera between a range

    I dont know if this is possible but what i am trying to add a check box into my spreadsheet. The journal can have upto 100+ lines i need to sum the values in column B IF the value in column A is between 500 and 599 (in example below it should return a value of 20) I have tried...
Back
Top