Hi.
Not sure if I should be using SUMIF( SUM(IF or SUMPRODUCT, but I cant seem to get what I want.
Thanks in advance for your solutions.
I Have 3 columns
A1: Work B1: Hours C1: Date
A2: Legal B2: 2 C2: 01/01/01
A3: Legal B3: 3 C3: 01/01/01
A4: Expenses B4: 2 C4: 01/01/01
A5: Other B5: 1 C5: 02/01/01
A6: Legal B6: 3 C6: 02/01/01
etc etc down to about 300 rows.
A300: Legal B300: 4 C300: 04/02/01
In plain english, what i'd like is a conditional sum to add the hours if the work type is legal and the date is greater than say 02/01/01 but less than say 09/02/01.
D4 contains the upper date and D5 the lower date.
D6 contains the "work area" i.e legal
What I have so far (generated partially by the conditional sum wizard), doesn't seem to work.
=SUM(IF(C2:C300<=D4, IF(C2:C300>=D5, IF(A2:A300=D6, B2:B300, 0),0),0)))
Any suggestions as to what is wrong, or what might be causing the problem?
If it would help I could post up a spreadsheet, but i would need to remove all the personal data.
Bookmarks