If statements looking for nonblank cells

[Mok721]

I need a formula to tell me which reports had a notification associated with
them. The spreadsheet is set up like such:

A B
1 4 300456
2 3 300258
3 1

Where Cells A1,A2 and A3 contain the type of report (1 to 11) and B cells
have a notification number if there is one. I need the formula to go through
my spreadsheet and tell me report #3 had one notification.

Any help would be greatly appreciated.

 

[T. Valko]

Try this:

A2:A20 = report type (numbers 1 to 11)
B2:B20 = notification number if there is one

Enter this formula in say, D2:

=ROWS(D$22)

Enter this formula in E2:

=SUMPRODUCT(--(A$2:A$20=D2),--(B$2:B$20<>""))

Select both D2 and E2 then copy down to D12:E12

D212 will return the report types in ascending sequential order and E2:E12
will return the counts.