| 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) | |||
Linear Mode
