I have read all the posts on sumproduct and have finally managed to get the
formula to work. What I was doing wrong was asking the answer to be placed on
a different worksheet from the table it was pulling information from. Is
there any way to create a formula that will put the information on a
different worksheet?

Background on my formula:
I have 3 columns
Date Days absent City

I want to sum the days absent on a specific day based on a specific city.
This is my formula which works if placed in the same spreadsheet as the table
pulling info from.

{=SUMPRODUCT(--(A1:A600=J6)*(E1:E600="<city name"),D1:D600)}

My reason for putting the information in another worksheet is because I want
to be able to create a trend chart that shows more than just days absent by
city. The original worksheet actually contains about 12 columns of data
(alothough I only need the 4 of the 12 for the trend charting). So it is
quite cumbersome to keep everything on one worksheet.

Any information is most appreciated.