Excel help please

[Colbaker]

Hi all, I am trying to do some things in Excel but i am a noob, Please can you help? Below is a mockup of a spreadsheet...

http://www.oneblondeeyebrow.co.uk/displayimage.php?album=random&cat=0&pos=-355

What i want to do is make a formula that will count the fields that have an earlier time in them than 18:00 but not on Saturday as Saturday i want to only count them if the time is before 12:00, Any idea how i should write this formula?

Also i want to do a formula that uses the counts in a percentage chart but what formula can i use? the problem is i could add more info to the spreadsheet so i would want it to only count a line that has info on it, any idea's what i can do there as well?

Thanks for the Help.

 

[dazzerd]

Not sure wht you mean by your second part but for the first part enter this formula in d3 and then drag down to the bottom of your list.


=IF(OR(AND(B3="Saturday",C3<0.5),AND(B3<>"Saturday",C3<0.75)),1,0)

This will tell you after each line whether or not it meets your criteria.

Just to note excel stores time as fraction of 24, so if you have 12 o clock it will divide it by 24 and treat it as 0.5.

You will then need to add anywhere

COUNTIF(D3 : Dxxx,1) where xxx is the end of your range.

You can do this in one go but its not worth the hassle to be honest especially if your an excel noob.

thanks