Just wondering if there is any advantage/disadvantage to using this formula where i reference the entrie col instead of specific range.
COUNTIFS(LNR_Inputfile!$B:$B,Portfolio_Summary!$A3)
Below is the same as above except i use specific rows.
COUNTIFS(LNR_Inputfile!$B$2:$B$200,Portfolio_Summary!$A3)
I would prefer to use the "top" one because then this protects me against variations in the number of rows on the LNR_Inputfile sheet. But is there a disadvantage to doing this? SPeed ? Memory?
Bookmarks