ry for inconvience.
>
> Thanks,
> Saurabh Patel
>
> --
> *From:* vivek agrawal [mailto:vivek.agrawa...@gmail.com]
> *Sent:* Wednesday, July 22, 2009 7:55 PM
>
> *To:* Saurabh
> *Subject:* Re: $$Excel-Macros$$ Re: Count of Status
>
> guess this is
o:vivek.agrawa...@gmail.com]
> *Sent:* Wednesday, July 22, 2009 7:55 PM
>
> *To:* Saurabh
> *Subject:* Re: $$Excel-Macros$$ Re: Count of Status
>
> guess this is what you want
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonli
;
> Sorry for inconvience.
>
> Thanks,
> Saurabh Patel
>
> --
> *From:* vivek agrawal [mailto:vivek.agrawa...@gmail.com]
> *Sent:* Wednesday, July 22, 2009 7:55 PM
>
> *To:* Saurabh
> *Subject:* Re: $$Excel-Macros$$ Re: Count of Status
>
> gue
Try this in C23:
=SUMPRODUCT(($C$2:$G$19="P")*($B$2:$B$19=B23))/SUMPRODUCT(($C$2:$G
$19<>"")*($B$2:$B$19=B23))
I wasn't too clear on what "non blank count of Team 1" should return,
so I took my best guess.
Angelo
On Jul 22, 6:49 am, "Saurabh" wrote:
> Hi All,
>
> I m having a trouble in attac
@googlegroups.com
Subject: $$Excel-Macros$$ Re: Count of Status
Hello Saurabh
Attached is the file with the proposed solution. Hope it helps
ALL THE BEST
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 4:19 PM, Saurabh wrote
Hello Saurabh
Attached is the file with the proposed solution. Hope it helps
ALL THE BEST
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 4:19 PM, Saurabh wrote:
> Hi All,
>
> I m having a trouble in attached file.
Hello.
Use :
=SUMPRODUCT(($B$2:$B$19=$B23)*(D$2:D$19="p"))/SUMPRODUCT(($B$2:$B$19=$B23)*(
D$2:D$19<>""))
In cell D23 (have a look at the attached file).
Hope this helps.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Saurabh
Sent: me
