If statements looking for nonblank cells
 

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.

If statements looking for nonblank cells
 

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$2:D2)

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

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

--
Biff
Microsoft Excel MVP


"Mok721" wrote in message
...
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.