Thread: SumIf in a Table
View Single Post
 
Old 01-19-2019, 01:32 PM
alpha alpha is offline Windows 10 Office 2010 64bit
Novice
  
Join Date: Jun 2018
Posts: 18
alpha is on a distinguished road
Default
When you add a column, the formula in A2, which is now =countif(c2:g2,"Yes"), changes automaticly in =countif(c2:h2,"Yes") .
The underlying cells in column A change accordingly.
Reply With Quote