|
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 |
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 |
| All times are GMT +1. The time now is 03:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com