Hi Guys,
I dont know if this would be a good enough suggestion to be considered
by all the members of the Group.
According to my experience, most of the users still use Excel 2003 and
they are not able to open files made in Excel 2007.
Would it be a good idea to share files of the Excel 2003 vers
mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, March 31, 2011 7:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need to count blank cells with CountIF formula
see the forumula in yellow .
On Thu, Mar 31, 2011 at 11:37 PM, wrote:
Hi,
I
ds that number to any blank cells
from those two criterias.
Thank you! Your help is appreciated J
~Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, March 31, 2011 7:24 PM
To: excel-macros@googlegroups.
see the forumula in yellow .
On Thu, Mar 31, 2011 at 11:37 PM, wrote:
> Hi,
>
> I have this formula,
> =COUNTIFS($E$5:$E$17,15,$G$5:$G$17,">=09:00:00",$G$5:$G$17,"<=19:00:00"),
> which returns to me a count total based on two criterias, but I also need to
> add in this same formula how many blan
Hi,
I have this formula,
=COUNTIFS($E$5:$E$17,15,$G$5:$G$17,">=09:00:00",$G$5:$G$17,"<=19:00:00"),
which returns to me a count total based on two criterias, but I also need
to add in this same formula how many blank cells there are, from E5:E17.
I did this formula:
=COUNTIFS($E$5:$E$17,1
