=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 34How 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

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.

do i crtl+shift+enter to get the { }

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.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History