IF formula..

  • Thread starter Thread starter GD
  • Start date Start date
G

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, 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..
 
=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
 
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?
 
Then you want Sumif, rather than Countif. Help contains a good description
of the function.

Regards,
Fred.
 
Back
Top