IF formula..
 

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..

IF formula..
 

=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..

IF formula..
 

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?

"Bernard Liengme" wrote:

=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..

IF formula..
 

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

Regards,
Fred.

"GD" wrote in message
...
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?

"Bernard Liengme" wrote:

=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..