IF "AM" add CELL B2:B3

  • Thread starter instereo911 via OfficeKB.com
  • Start date
I

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.
 
P

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
 
Top