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
Your formula is not a Vlookup formula.
Attaching a sample workbook could help getting your question answered faster.
It might be a good idea to change your thread title. Go to your 1st post in this thread , select edit then Advance to change you title to one that matches your question.
I know...I'm re posting it correctly. Made a mistake that's why I marked it solved.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks