SUMIFS() Not Working in Excel (Office 365) on MacBook

Hi all,

Here is a screen snip of part of my workbook. August is on Row 1

[ATTACH=JSON]{"data-align":"none","data-size":"full","title":"Screen Shot 2019-07-05 at 6.36.59 pm.png","data-attachmentid":1220059}[/ATTACH]

Here is my formula in cell I126, which is the December "Less: Expenditure"

=-SUMIFS(Transactions!$H:$H,Transactions!$A:$A,">="&H24,Transactions!$A:$A,"<="&H30)-SUMIFS(Transactions!$J:$J,Transactions!$A:$A,">="&H24,Transactions!$A:$A,"<="&H30)

What seems to happen is it seems to be using cells H13 and H19 instead of H24 and H30.

Here is a snip of the two relevant lines in the second quarter (in Australia, we run from June to July)

[ATTACH=JSON]{"alt":"Click image for larger version Name:\tScreen Shot 2019-07-05 at 5.37.36 pm.png Views:\t3 Size:\t30.9 KB ID:\t1220055","data-align":"none","data-attachmentid":"1220055","data-size":"full","title":"Screen Shot 2019-07-05 at 5.37.36 pm.png"}[/ATTACH]

There are no merged cells, so:
Date = Column A
Expend = Column H
GST = Column J

Can someone please help me find the answer?

Thank you,

Neil

PS: Don't bother buying this - it is better to go out and buy a Windows PC or Laptop. Things like create/edit UserForms are missing from VBA and Evaluate Formula is missing from Excel - not very good at all :confused:

Thank you, AliGW

Here is the workbook

2018-2019 Church Finances RAB.xlsm

I'm in the process of designing it; hence there are some items not finished (like a button to remove data from some pages, and reviewing for other errors)

Regards,

Neil