Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum on a count of 45
I have information that looks like this.
Name1 Name2 Name3 Wed 11/01 N 0 1 Thu 11/02 N 1 0 It has the name going across and the date down the side. You can ignore the N that is a seperate column that is used. What I need to do is for a given date lets say 5/1, I need to count back 45 0's or 1's, and sum that amount. The problem is not everyone has a count for that day. Any suggestions or how I can find out what date I have to go back to find a count of 45 so I can sum off of that date? Thanks Vick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |