Good morning,

I have a problem that I can't seem to figure out. I have attached a same section of the spreadsheet i am working on.

I need to write a formula that sum's column J on the "F-30 Data" tab. The formula is based on Sheet 1 so I put some place holders.

What I need is the formula to go out to that F-30 data tab,

1 - Look at column "A" if it is

**equal** to 1334509

2 - Look at column "E" if it is

**equal** to Z00

3 - Look at Column "N" if it is

**equal** to "Saturday" or "Sunday"

4 - Look at Column "L" if it is

**not equal** to 22 or 24 (so it would include everything else)

then sum column Column J.

I have tried everything and can't seem to get it to work.

book1.xls
=SUM(SUMIFS('F-30 Data'!J:J,'F-30 Data'!A:A,B5,'F-30 Data'!N:N,{"Saturday","Sun

regards, barry