G
Guest
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
,"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
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
,"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