Posted to microsoft.public.excel.misc
|
|
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..
|