GingerNinja
New Member
Hi to all the awesome Excellers!
I have a problem i cant seem to get around, here goes;
I'm using a countif formula for a specific range of cells, but i realise as the months go by, i need the formula to have a dynamic range that will change if and when needed to. I'm using random dates, numbers and cells in my explanation.
Range C2:Q2 has dates in them, they change from time to time, for this eg 1 Jan to 15 Jan
The current formula looks similar to this countif(C3:L3,"A") and i drag it down a column
I'm wanting that if eg, 1 Jan is in cell C2 but then next time changes to D2 as well as 10 Jan being in L2, how would i type a countif formula that would change the range in the formula automatically from C3:L3 to D3:M3? But it must refer to the dates 1 Jan and 10 Jan.
And i need it to be able to be dragged down a column.
I'm using Excel 2010 and the end users also only have Excel 2010, so no need for compatibility checks. I'll put up a sample workbook if this was too vague.
The workbook is a daily production log that logs the products made per person per day. I have allocated letters to the products that are made, hence the use of countif formulae. Different products are made on different days so I'll be using A or B or C etc in the formula, but lol, i dont need help with that
And the full sheet has the dates from 1 Jan through to 31 Dec, but i'll be using specific ranges of 10 days each range, its just that the dates can change in the cells due to other controlling formulae.
I have a problem i cant seem to get around, here goes;
I'm using a countif formula for a specific range of cells, but i realise as the months go by, i need the formula to have a dynamic range that will change if and when needed to. I'm using random dates, numbers and cells in my explanation.
Range C2:Q2 has dates in them, they change from time to time, for this eg 1 Jan to 15 Jan
The current formula looks similar to this countif(C3:L3,"A") and i drag it down a column
I'm wanting that if eg, 1 Jan is in cell C2 but then next time changes to D2 as well as 10 Jan being in L2, how would i type a countif formula that would change the range in the formula automatically from C3:L3 to D3:M3? But it must refer to the dates 1 Jan and 10 Jan.
And i need it to be able to be dragged down a column.
I'm using Excel 2010 and the end users also only have Excel 2010, so no need for compatibility checks. I'll put up a sample workbook if this was too vague.
The workbook is a daily production log that logs the products made per person per day. I have allocated letters to the products that are made, hence the use of countif formulae. Different products are made on different days so I'll be using A or B or C etc in the formula, but lol, i dont need help with that