Please check the attachment below.
In "Overview" > Cell C3, I have the below formula
=SUMIFS(REVENUES!$K$2:$K$60,REVENUES!$D$2:$D$60,$A3,REVENUES!$M$2:$M$60,C$2)
I want to transform the specified range 2:60 into the entire column. I tried changing it as $K$K for the first one for instance, but it didn't work, unless I missed something?
I know it's not recommended for performance reason, but entire column ensures no value ever get missed.
Your help is appreciated. Thanks
Well, it's $K:$K
But if you don't want to use a structured table you can use dynamic named ranges:BILL_YEAR =REVENUES!$D$2:INDEX(REVENUES!$D:$D,Rec_Count)
Rec_Count =MATCH("ZZZZZ",REVENUES!$A:$A)
STATUS =REVENUES!$M$2:INDEX(REVENUES!$M:$M,Rec_Count)
TOTAL_HTVA =REVENUES!$K$2:INDEX(REVENUES!$K:$K,Rec_Count)
C3:
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks