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