LinkBack URL
About LinkBacks
Delta729 
I was using a name range as array, but it's still not working right. This is what I have now.
Sum(SUMIFS(DataTbl[Voucher Count],DataTbl[Month],J12,DataTbl[Year],J11,DataTbl[Group],H15,DataTbl[CG-type],"<>"&"Fedex","Concur","Postmaster",""))
I was using a name range as array, but it's still not working right. This is what I have now.
Sum(SUMIFS(DataTbl[Voucher Count],DataTbl[Month],J12,DataTbl[Year],J11,DataTbl[Group],H15,DataTbl[CG-type],"<>"&"Fedex","Concur","Postmaster",""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks