=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