Hi all,
I am looking for a little help with the COUNTIFS formula.
I have the COUNTIFS working for a defined range but would like to expand this for a full column.
As the column now contains blank cells, I get the dreaded #VALUE! response.
I have used the below formula for the Supplier 1 result.
=COUNTIFS(A5:A14;"Supplier 1";B5:B14;"Supplier")
The attached file shows an example of an Issue Log & Issue Tracker.
The Issue Tracker should hopefully only display the number of issues defined as Supplier on the Log.
Any help with this would be appreciated.
Thanks,
Niall
Bookmarks