Hi,

I need to calculate a total, based on the following conditions.

On sheet 2 I need to display a value in a cell totaling the money spent from
a list of values in sheet 1.

I need to ensure that the following criteria are met in performing the
calulation, on sheet 1 I have 2 text fields and a date field.
I need to add together all costs in say column F, where the text in field A
is "Project1", the text in field B is "consumables" and the contents of
Field C (a Date) is not NULL.

I have several text values so I need to filter out only the values I'm
interested in (i.e. Project1, Project2) and (Consumables, Hardware etc). Can
anyone point me in the direction of some code that I could acheive this with
without me having to filter the spreadsheet and manually total it all up.

Regards

Jonathan