I am trying to do a sum based on two separate criteria:
=SUMIFS(A3:A163,"<=30/06/2006",C3:C136,">=0",c3:c136)
Col A = dates
Col C = Amounts (there are negative and positive amounts)
So basically, I am grouping financial years (Aus) that are not negative numbers (invoiced amounts) and a separate one for negative numbers (payments).
What am I doing wrong?
=SUMIFS(A3:A163,"<=30/06/2006",C3:C136,">=0",c3:c136)
Col A = dates
Col C = Amounts (there are negative and positive amounts)
So basically, I am grouping financial years (Aus) that are not negative numbers (invoiced amounts) and a separate one for negative numbers (payments).
What am I doing wrong?