IF "AM" add CELL B2:B3

[instereo911 via OfficeKB.com]

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.

 

[Peo Sjoblom]

=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