Dear Aamir,
very simple 13 mean 1 pm and 14 mean 2 pm
but as per your example sheet you should need to replace 14 to 15..
because 15 mean 3 to 3
On Fri, Jan 13, 2012 at 10:46 PM, Aamir Shahzad wrote:
> Dear Maries/Anjul Porwal,
>
> Why tou use "13" in your formula. can you brief?
>
> Regards
Dear Maries/Anjul Porwal,
Why tou use "13" in your formula. can you brief?
Regards,
Aamir Shahzad
On Fri, Jan 13, 2012 at 6:21 PM, Rajan_Verma wrote:
> See the attached
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anil Saxena
> *Sent:*
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 the
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