Forum Discussion
Help: Excel Formula and Tables
Hi all, Wondering if someone can help? I have a excel table of data. Outside of the table I have numerous countif formula's. Example: =COUNTIF(January_2019_Submitted_Forms[#All],"206")+COUNTIF(...
Hi ExcelLewis
You could do a copy paste and then highlight all the formula and replace January_2019 with February_2019 (Ctrl + H)
Not that I know your data but if you could keep it all in a single table called Submitted_Forms and then add an extra column for Month to flag which entries are January , February etc then reporting would be easier via Pivot Tables or COUNTIFS