SumIf in a Table

		Microsoft Office Forums > Microsoft Excel > Excel
SumIf in a Table

FAQ

Thread Tools

Display Modes

01-19-2019, 01:32 PM

alpha

Windows 10 SumIf in a Table

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumif within VBA	Lee-Ann	Excel Programming	6	09-28-2017 07:38 AM
SUMIF with Or	Lluewhyn	Excel	6	02-17-2017 10:48 AM
Another SUMIF	OTPM	Excel	6	06-06-2016 03:00 AM
VBA sumif	Nisio07	Excel Programming	0	02-26-2016 07:53 AM
Average if and sumif	jennamae	Excel	4	01-17-2014 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:37 AM.