Summary counting
 

I have the need to create a quantity summary of information from two types of
text

It is as follows: (all columns have a list of information from which a word
can be choosen - no text can be inputted)

(A1) (B1)
happy D
sad A
tired A
Awake D
happy A
etc.

So the summary should read
(c1)=COUNTIF(A1:A5;"happy") - the result would be 2
(d1) "the question" how do ask for the count of c1 and the criteria of D -
The result would be 1
(e1)"the question" how do ask for the count of c1 and the criteria of D -
The result would be 1

Thanks for any help

Summary counting
 

For multiple criteria you want sumproduct something like this

=SUMPRODUCT(--(A1:A5="happy"), --(B1:B5="D"))

Here is a link to a full explanation of sumproduct...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"John" wrote:

I have the need to create a quantity summary of information from two types of
text

It is as follows: (all columns have a list of information from which a word
can be choosen - no text can be inputted)

(A1) (B1)
happy D
sad A
tired A
Awake D
happy A
etc.

So the summary should read
(c1)=COUNTIF(A1:A5;"happy") - the result would be 2
(d1) "the question" how do ask for the count of c1 and the criteria of D -
The result would be 1
(e1)"the question" how do ask for the count of c1 and the criteria of D -
The result would be 1

Thanks for any help

Summary counting
 

Thanks a lot, Whilst the formula you gave me didn't sort out the problem -
the link you kindly provided worked like a dream.

Thanks

"Jim Thomlinson" wrote:

For multiple criteria you want sumproduct something like this

=SUMPRODUCT(--(A1:A5="happy"), --(B1:B5="D"))

Here is a link to a full explanation of sumproduct...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"John" wrote:

I have the need to create a quantity summary of information from two types of
text

It is as follows: (all columns have a list of information from which a word
can be choosen - no text can be inputted)

(A1) (B1)
happy D
sad A
tired A
Awake D
happy A
etc.

So the summary should read
(c1)=COUNTIF(A1:A5;"happy") - the result would be 2
(d1) "the question" how do ask for the count of c1 and the criteria of D -
The result would be 1
(e1)"the question" how do ask for the count of c1 and the criteria of D -
The result would be 1

Thanks for any help