Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#4
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|