The following formula is not returning the correct data from the data source
=SUMIFS(Gifts!$C:$C,Gifts!$U:$U,"kcl non subject specific",Gifts!$D:$D,"HVKHP")+SUMIFS(Gifts!$C:$C,Gifts!$U:$U,"kcl non subject specific",Gifts!$D:$D,"HVU")
Can someone help me in why it may not be working?? All other formulas work fine in the workbook besides this one.
Thanks
Bookmarks