Changing only date in countif logic

April 13, 2011 at 06:47:52
Specs: Windows XP
=COUNT(IF('MI Packages shipped'!$B$2:$B$21782="11/25/2010",IF('MI Packages shipped'!$D$2:$D$21782="oz",IF('MI Packages shipped'!$C$2:$C$21782=1,))))

Im using the formula above across for months of data

Weights 8-Nov 9-Nov 10-Nov 11-Nov 12-Nov 15-Nov
1oz 0 0 0 0 0
2oz 0 0 1 0 0
3oz 0 0 0 0 0
4oz 0 12 6 3 5
5oz 0 12 7 8 2
6oz 0 81 27 30 34

How can i plug in the formula into 16-NOV without having to change the date in each cell. And going on through April??
I am using Excel 2010


See More: Changing only date in countif logic

Report •

#1
April 19, 2011 at 12:33:38
You can use Edit...Replace to Replace parts of a formula or you could put your dates in a cell (e.g. A1) and change your formula to:

=COUNT(IF('MI Packages shipped'!$B$2:$B$21782 = A1, .....

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 19, 2011 at 12:37:33
do i crtl+shift+enter to get the { }

Report •

#3
April 20, 2011 at 05:44:54
Huh?

Why are you suggesting turning the given formula into an array formula?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question