=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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History