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"


    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,


    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:

  • You would be better off attaching the workbook so that somebody with one of those Mac thingies (yuck!) can check it for you. :)

    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules