na
>> *Sent:* Jan/Fri/2012 02:46
>> *To:* Dilip Pandey
>> *Cc:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Plz do the needful
>>
>>
>>
>> Hi All,
>>
>> Plz find the attached file and mention the formula.
>>
>>
>
half Of *Anil Saxena
> *Sent:* Jan/Fri/2012 02:46
> *To:* Dilip Pandey
> *Cc:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Plz do the needful
>
>
>
> Hi All,
>
> Plz find the attached file and mention the formula.
>
>
>
>
>
> --
See the attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Saxena
Sent: Jan/Fri/2012 02:46
To: Dilip Pandey
Cc: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Plz do the needful
Hi All,
Plz find the attached file and mention
Hi Anil,
Also can use below formula,
=SUM(--(HOUR(B2:B50)=13)*--((A2:A50)=D3))
(With Ctrl+Shift+Enter)
Regards,
MARIES.
On Fri, Jan 13, 2012 at 3:21 PM, Anjul Porwal wrote:
> hi Anil,
>
>
> please use
>
> =SUMPRODUCT(--(HOUR($B$2:$B$50)=13)*($A$2:$A$50=D$3))
>
> Regards
> Anjul
>
>
>
>
>
>
hi Anil,
please use
=SUMPRODUCT(--(HOUR($B$2:$B$50)=13)*($A$2:$A$50=D$3))
Regards
Anjul
On Fri, Jan 13, 2012 at 2:45 PM, Anil Saxena wrote:
> Hi All,
> Plz find the attached file and mention the formula.
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concis
Hi All,
Plz find the attached file and mention the formula.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Hi Dilip Ji
Plz Do the Needful and show the Formula also
Ram is 2
Regards,
Anil Saxena
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excelda
