IF formula..

[GD]

Hey, is it possible to put together a formula which will identify a text
arrangement (i.e "Subject A") from a range of cells, G330 - 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..

 

[Bernard Liengme]

=COUNTIF(G330,"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(G330,R1)
best wishes

 

[GD]

Ah ok nice one, so say I have this formula and the cell is reporting "1" for
the amount of times the text appears in the given range, how would I then put
together a formula that will total the numerical figures in another range, IF
the cell the original formula is in is reporting greater than zero?

 

[Fred Smith]

Then you want Sumif, rather than Countif. Help contains a good description
of the function.

Regards,
Fred.