PC Review


Reply
Thread Tools Rate Thread

Count problems

 
 
Sqdncall
Guest
Posts: n/a
 
      3rd Mar 2009
I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      3rd Mar 2009
Hi,

=SUMPRODUCT((A1:A100="A")*(B1:B100=""))

Mike

"Sqdncall" wrote:

> I am trying to count a range of cells based upon their value and another
> corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
> the corresponding B1:B100 cell. Is this possible?
>
> Thank you in advance
> --
> Sqdncall

 
Reply With Quote
 
Sqdncall
Guest
Posts: n/a
 
      3rd Mar 2009
Thank you Mike ! Works great!
--
Sqdncall


"Mike H" wrote:

> Hi,
>
> =SUMPRODUCT((A1:A100="A")*(B1:B100=""))
>
> Mike
>
> "Sqdncall" wrote:
>
> > I am trying to count a range of cells based upon their value and another
> > corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
> > the corresponding B1:B100 cell. Is this possible?
> >
> > Thank you in advance
> > --
> > Sqdncall

 
Reply With Quote
 
Shane Devenshire
Guest
Posts: n/a
 
      3rd Mar 2009
Hi,

If you are using 2007:

=COUNTIFS(A1:A100,"A",B1:B100,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sqdncall" wrote:

> I am trying to count a range of cells based upon their value and another
> corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
> the corresponding B1:B100 cell. Is this possible?
>
> Thank you in advance
> --
> Sqdncall

 
Reply With Quote
 
Shane Devenshire
Guest
Posts: n/a
 
      3rd Mar 2009
Hi,

In 2003 or 2007 you can also use this

=SUMPRODUCT(--(A1:A8&B1:B8="A"))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sqdncall" wrote:

> I am trying to count a range of cells based upon their value and another
> corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
> the corresponding B1:B100 cell. Is this possible?
>
> Thank you in advance
> --
> Sqdncall

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count if problems mjlunt Microsoft Excel Worksheet Functions 8 28th Jul 2008 09:47 PM
Count Problems =?Utf-8?B?V01vcnNiZXJnZXI=?= Microsoft Access 1 31st Oct 2006 01:58 PM
Count Problems =?Utf-8?B?TWFyYw==?= Microsoft Access Reports 1 13th Jun 2005 05:25 AM
COUNT problems rotcod Microsoft Access Reports 2 23rd Jan 2004 06:28 PM
COUNT problems rotcod Microsoft Access Reports 0 22nd Jan 2004 09:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:32 PM.