I'd probably use a Pivot Table to evaluate this.

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm


"JessJ" wrote in message
...
Please help me. Here is a very simplified example of my spreadsheet.

A B C D E
1 Text Subject Food Drink Reason
2 A1a A1 1 12 Work
3 A1b A1 0 4 Work
4 A3 A3 3 0 Pain
5 A5a A5 0 0 Work
6 A5b A5 0 0 Work
7 A5c A5 0 0 Work

I have formulae for the following two types of totals. The "count by text"
represents all the number of texts which contain words relating to Food or
Drink.

Total Occurrences: 4 16
Count by Text: 2 2

But how can I get the three sets of totals below?

Count by Subject 2 1
Pain by Subject 1 0
Work by Subject 1 1

How can I get counts by subjects? (I know I could use the "Subtotal"
wizard, and then check for the word "Total", but this would not enable me
to
also use the "Reason" conditions.)

Texts are unique per row (at least, as far as this example is concerned).
Each subject may have written more than one text. Food an Drink are
categories of words, and columns C and D show the number of times such
words
occur in a text. Each subject may have only one "Reason" attribute; but a
"reason" attribute may pertain to more than one subject.

Any help would be appreciated.

JessJ
--
Jess
(XP Home SP/2 OEM. HDD1:Windows NTFS 280GB; Fat32 1GB; Linux 19GB.
HDD2: NTFS 80GB. HDD3: NTFS 40GB. P4 HT. 512MB)
[Please note: Display name changed from Jess. I want to be unique!]