alsexceladmin
Board Regular
- Joined
- Jan 17, 2005
- Messages
- 62
Hi All,
I need to add to or amend my current formulae to help me produce a more definitive list for my boss!
I am currently using the count formulae =sumproduct(range="yes")*(range="is") to search 500 rows/cols and give me a count for six different variables. Namely - "yes" or "no" from col C, times "IS", "IB" or "IS/IB" from col D.
I have the count results set out in a table below the spreadsheet which is approx 500 rows each month.
I am now being asked, will I produce a list/table with the sort/count breakdown by weeks, using dates from the spreadsheet? These dates are entered in random order as required.
The end product would hopefully give me a count for example: YES from col A * IS from col B * (each occurence on dates say- 01/04/2006: 06/04/2006).
Then again for same but with dates 07/04/2006:12/04/2006 and so on etc.
Can anyone help me please?
Thanks in advance!
Alan
I need to add to or amend my current formulae to help me produce a more definitive list for my boss!
I am currently using the count formulae =sumproduct(range="yes")*(range="is") to search 500 rows/cols and give me a count for six different variables. Namely - "yes" or "no" from col C, times "IS", "IB" or "IS/IB" from col D.
I have the count results set out in a table below the spreadsheet which is approx 500 rows each month.
I am now being asked, will I produce a list/table with the sort/count breakdown by weeks, using dates from the spreadsheet? These dates are entered in random order as required.
The end product would hopefully give me a count for example: YES from col A * IS from col B * (each occurence on dates say- 01/04/2006: 06/04/2006).
Then again for same but with dates 07/04/2006:12/04/2006 and so on etc.
Can anyone help me please?
Thanks in advance!
Alan