=COUNTIF(G3:P30,"Subject A")
will count how many cells in the range have this text value
If cell R1 has value "Subject A" they you may use =COUNTIF(G3:P30,R1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GD" wrote in message
...
Hey, is it possible to put together a formula which will identify a text
arrangement (i.e "Subject A") from a range of cells, G3:P30 - BUT once
it's
identified it, will tally a numerical value in the adjacent cell?

Essentially the data has been input as names with numbers representing a
time next to them, i'm looking to draw out the total figure of all those
numbers to represent a cumulative time regardless of the amount of times
the
text arrangement appears - it's just the total numerical figure for each
"Subject" i'm interested in..