Count unique if another cell not blank

[DanielleParker7]

Hiya,

I have got part way through a formula but need some help.

I am making some KPI's so have a separate sheet that is looking to count some information.


Cells are:

Invoice Number - 'Main Sheet'!$AA$3:$AA$9998
Invoice Passed to A&F - 'Main Sheet'!$AE$3:$AE$9998


If there is a date in column AE (Invoice passed to A&F) then I need it to count unique values in the invoice number column (AA).

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER('Main Sheet'!AA3:AA9998,'Main Sheet'!AE3:AE9998<>"")))

 

[DanielleParker7]

How about

=ROWS(UNIQUE(FILTER('Main Sheet'!AA3:AA9998,'Main Sheet'!AE3:AE9998<>"")))

That's worked! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.