tag:blogger.com,1999:blog-7826720847639113939.post5335445579697100678..comments2024-03-24T14:34:25.522-07:00Comments on Excel Spreadsheets Help: 20 Excel Shortcuts You Need to Know. Number 15 is My Favorite.Nickhttp://www.blogger.com/profile/15585454339530843458noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7826720847639113939.post-5337489187521134242021-03-11T11:36:45.958-08:002021-03-11T11:36:45.958-08:00Is it possible to have an INDIRECT formula that ca...Is it possible to have an INDIRECT formula that can also increment (+1) with respect to the row range being referenced? In the ex below, I'd like for E277:Z277 to become E278:Z278, E279:Z279, etc., when I drag down.<br /><br />=SUMPRODUCT(COUNTIF(INDIRECT("'"&NSS_UnR_Sht_Names&"'!E277:Z277"),"alert"))Rose_Wmshttps://www.blogger.com/profile/08011668580589400996noreply@blogger.com