Hi,

I am really struggling here, have trawled the web but cannot find any help.

I have 2 columns.

A1 contains a date 'Date Raised'

B1 contains a validated drop down 'Status' containing 'Open', 'Closed' & 'Accepted'

I need the query to look through the 'Date Raised' coulmn and identify any dates that are greater than 30 days but less than 120 days outstanding. I then need the query to look at the corrosponding 'Status' column and identify if those records which meet the date criteria have 'Open' or 'Accepted' in their status (I want to ignore all 'Closed' records)

I have tried a lot (and I mean a lot) of different combinations of sumproduct but it is not working,

any help would be greatly appreciated