I need to quickly check a large amount of data for the following:

Look at column B and if there are multiple entries for the same reference
number, look at column F and add the totals for that reference number and if
it equals 0, identify those items with 'nil'

Can anyone help me write a formula that will accomplish this??

Thanks in advance.

Shazza