Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-03 Thread ashish koul
do you want to sum all the values of Fridays of each month On Wed, Oct 2, 2013 at 6:09 PM, wrote: > > > On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: >> >> vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value >> should be 5. >> > > Plse refer to the

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread koul . ashish
Can u explain it in detail Sent on my BlackBerry® from Vodafone -Original Message- From: asd...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 Oct 2013 01:22:20 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: total Fridays in a range On

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Wednesday, October 2, 2013 4:07:13 PM UTC+8, ashish wrote: > > can u share hw wuld u like to see thn > > if SUM((WEEKDAY(A2:A6)=6)) = 5 then .. > > On Wed, Oct 2, 2013 at 1:01 PM, > wrote: > >> >> >> On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: >>> >>>

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread ashish koul
can u share hw wuld u like to see thn On Wed, Oct 2, 2013 at 1:01 PM, wrote: > > > On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: >> >> vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value >> should be 5. >> > > run your vba, the result as shown on Sna