Formula Help

[glerwell]

Hi

I'm trying this formula which isn't returning what I expect:

=SUMIFS(INDEX(Q:Q,13):INDEX(Q:Q,$AO$21),INDEX(D:D,13):INDEX(D:D,$AO$21),$AO$27,INDEX(B:B,13):INDEX(B:B,$AO$21),[COLOR="Red"](YEAR(AE60)[/COLOR]))

The problem I think is with the highlighted area.

AE60 is a year ie, 2011 (formatted as general). Column B are dates in dd-mm-yyyy format.

So basically I want to only sum the rows, in which column D matches AO27 and and any dates in column B that are within the year specified in AE60.

Any ideas?

Cheers

 

[shg]

Without looking at the rest of it, change

..., (YEAR(AE60))

to

..., AE60


Year of the serial date 2011 is 1905.