H
Hammer
I need to sum a range(columns H1:K6) that meets certain criteria (between to
dates)EX:2007-10-01 thru 2007-10-31.Dates are unknown and not consistant.
My table starts fresh with each fiscal year(october 1). EX:
A B C D E F G H
I J K
1 07/10/01 100.00
50.00
2 07/10/25
25.00 200.00
3 07/10/31 100.00 5.00
25.00
4 07/11/07
500.00 30.00
5 07/11/30
6 07/12/23 100.00 10.00
20.00
dates)EX:2007-10-01 thru 2007-10-31.Dates are unknown and not consistant.
My table starts fresh with each fiscal year(october 1). EX:
A B C D E F G H
I J K
1 07/10/01 100.00
50.00
2 07/10/25
25.00 200.00
3 07/10/31 100.00 5.00
25.00
4 07/11/07
500.00 30.00
5 07/11/30
6 07/12/23 100.00 10.00
20.00