My weekday function aint working

Kimberly · #1 05-25-2010, 03:10 PM

I didn't mean to seem rude either.

In a helper column: =IF(AND(WEEKDAY(A3,2)<6,MOD(A3,0.5)=0),"yes","no")
then =AVERAGEIF(C3:C289,"yes",B3:B289)

FraserKitchell · #2 05-25-2010, 03:35 PM

I like that formula. And it seems to work just fine. I'll call this one solved.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lastincolumn function	rdcsfd	Excel Programming	7	02-08-2012 07:50 AM
FIND function, where?	Yumin	Word	2	04-02-2010 07:16 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM
Need help on what function to use???	Primeraman	Excel	1	06-13-2006 10:16 AM
Help with Combination function	sanasath	Excel	0	12-13-2005 07:24 AM