Hi all,

OK here goes:

I have this workbook which contains many worksheets.
On one page, I need to do a tally of some info in our first sheet.
These aren't numbers but categories, etc. in other words, it is text.

My first colum - i need to add how many of each "word" repeats itself in
that row.
Formula: =COUNTIF(Activities!D:D,"ESS")
(activites is my worksheet, Column D, word is ESS)
Works like a charm - I get the right amount.

Now...it gets a bit more complicated and that's where I'm stuck.
I need to count how many in, let's say ESS as above are On-Going, Completed,
On-Hold. (labeled in column E of my first worksheet).

So I need a formula that will calculate the same calculation above but
adding the critiria of another column with additional text (On-Going,
Completed, On-Hold).

I can't seem to find the correct formula anywhere... and I know this must be
doable. HELP!

Thanks :-)

Chantal

Hi

=SUMPRODUCT(--(Activities!$D$1:$D$1000="ESS"),--(Activities!$E$1:$E$1000="On
-Going"))
, etc.
NB! You can't refer to whole column with SUMPRODUCT!


Arvi Laanemets


"chantal0123" wrote in message
...
Hi all,

OK here goes:

I have this workbook which contains many worksheets.
On one page, I need to do a tally of some info in our first sheet.
These aren't numbers but categories, etc. in other words, it is text.

My first colum - i need to add how many of each "word" repeats itself in
that row.
Formula: =COUNTIF(Activities!D:D,"ESS")
(activites is my worksheet, Column D, word is ESS)
Works like a charm - I get the right amount.

Now...it gets a bit more complicated and that's where I'm stuck.
I need to count how many in, let's say ESS as above are On-Going,
Completed,
On-Hold. (labeled in column E of my first worksheet).

So I need a formula that will calculate the same calculation above but
adding the critiria of another column with additional text (On-Going,
Completed, On-Hold).

I can't seem to find the correct formula anywhere... and I know this must
be
doable. HELP!

Thanks :-)

Chantal