Wed, Nov 27, 2013 at 10:28 PM, ashish koul wrote:
> =SUMIFS($D$2:$D$63,$C$2:$C$63,"*pm")/COUNTIF($C$2:$C$63,"*pm*")
>
> use same for am
>
>
> On Thu, Nov 28, 2013 at 8:53 AM, Noel Sherry wrote:
>
>> Sure Ashish,
>> That was a quick response.
;
> On Thu, Nov 28, 2013 at 8:53 AM, Noel Sherry wrote:
>
>> Sure Ashish,
>> That was a quick response. I just joined this forum and posted my
>> question. I have put a sample Excel attached to this to show the problem.
>> The first column is the date, second column
gt;
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscrib
*
*Salt Lake City, UT*
*Shilpa*
*Informatica Developer*
*Hopkins, MN*
*Salt Lake City, UT*
*Sneha*
*Java Developer*
*Kansas City, MO*
*Only TX*
*Thanks & Regards**...**?*
* *
*Sherry*
*NITYA** **Software Solutions, Inc***
*Direct:801-833-0416; Office : 801-983-2771; Fax:801
*
*Salt Lake City, UT*
*Shilpa*
*Informatica Developer*
*Hopkins, MN*
*Salt Lake City, UT*
*Sneha*
*Java Developer*
*Kansas City, MO*
*Only TX*
*Thanks & Regards**...**?*
* *
*Sherry*
*NITYA** **Software Solutions, Inc***
*Direct:801-833-0416; Office : 801-983-2771; Fax:801
*
*Salt Lake City, UT*
*Shilpa*
*Informatica Developer*
*Hopkins, MN*
*Salt Lake City, UT*
*Sneha*
*Java Developer*
*Kansas City, MO*
*Only TX*
*Thanks & Regards**...**?*
* *
*Sherry*
*NITYA** **Software Solutions, Inc***
*Direct:801-833-0416; Office : 801-983-2771; Fax:801
*
*Salt Lake City, UT*
*Shilpa*
*Informatica Developer*
*Hopkins, MN*
*Salt Lake City, UT*
*Sneha*
*Java Developer*
*Kansas City, MO*
*Only TX*
*Thanks & Regards**...**?*
* *
*Sherry*
*NITYA** **Software Solutions, Inc***
*Direct:801-833-0416; Office : 801-983-2771; Fax:801
