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