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