silvertears
New Member
- Joined
- Aug 27, 2004
- Messages
- 4
=COUNTIF('January!B3:AF3,February!B3:AF3,March!B3:AF3,April!B3:AF3,May!B3:AF3,June!B3:AF3,July!B3:AF3,August!B3:AF3,September!B3:AF3,October!B3:AF3,November!B3:AF3,December!B3:AF3,B1)
I am trying to get it to count cells that match cell B1 on the end there on those 12 sheets (1 for each month). It doesn't want to do more than one sheet at a time though. Got any ideas apart from doing each sheet separately and than adding those up?
I am trying to get it to count cells that match cell B1 on the end there on those 12 sheets (1 for each month). It doesn't want to do more than one sheet at a time though. Got any ideas apart from doing each sheet separately and than adding those up?