Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF "AM" add CELL B2:B3
Hello -
I have an excel sheet that looks like this: QUEUE NUMBER AM 92 AM 31 CU 45 CU 03 CU 68 I was wondering if there is a quick way of saying "If QUEUE is AM than add number next to it" Make sense... I don't make sense most of the times. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200705/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF "AM" add CELL B2:B3
=SUMIF(Queue_Range,"AM",Number-Range)
or better =SUMIF(Queue_Range,H2,Number-Range) where H2 holds AM or whatever criteria you choose replace Queue and Number range with the real cell reference -- Regards, Peo Sjoblom "instereo911 via OfficeKB.com" <u27979@uwe wrote in message news:722eca4192712@uwe... Hello - I have an excel sheet that looks like this: QUEUE NUMBER AM 92 AM 31 CU 45 CU 03 CU 68 I was wondering if there is a quick way of saying "If QUEUE is AM than add number next to it" Make sense... I don't make sense most of the times. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200705/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |