Dear Amresh,
simple way is to calculate seprately for Mumbai & Delhi & then add it
COUNTIF(A1:A8,"=Mumbai")
COUNTIF(A1:A8,"=Delhi")
On Thu, Jul 9, 2009 at 1:05 PM, amresh kumar wrote:
> Hi Team,
>
> i want learn more of countif function.
>
> example
>
>City Delhi Mumbai Maharas
Dear Friends,
I have a below schedule which contains date wise & 1 hour slot wise areas.
can i have its output such that its takes date & time from system & shows me
only the specific cell as an output
Input Sheet Date 07/05/2009 07/06/2009 07/07/2009 07/08/2009 Time band
12:00-1:00
Dear Friends,
Pl help me to enter in the yellow cell the information from table 2 based on
the highlighted (red) date
*06/02/2009* ** ** *Date* *0 - 1 * *DURATION (Hrs.)* *No. of instances*
** *06/01/09* 16 *0 - 1* *06/02/09* 8 *1 - 2* *06/03/09* 10 *2 - 3
* *06/04/09* 11 *3 -
Dear Friends,
it can also be done through www.*pdftoexcel*online.com
wherein u can upload the pdf file & enter you mailing address.
the pdf converted excel sheet is mailed to u...no verification or
registration reqd.
try it out
On Mon, Mar 23, 2009 at 10:48 AM, Tanzeem Ahmad wrote:
> Dear Ma
Hey..Dilip
that was great...
On Tue, Jun 16, 2009 at 4:16 PM, Dilip Pandey wrote:
> Hi ac737,
>
> This is actually a good query. Same is solved and attached. Thanks.
> Dilipandey
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@y
