Hi,
First post so here goes..
I have data in 2 columns say a & b.
A b
Item log
123 packed
124 packed
123 shipped
123 delivered
124 shipped
125 packed
So I need to count the items that meet 2 criteria in column b - so say it's packed and delivered.
I've tried to filter for the packed and copy this data into a separate sheet then perform a countif on this data to see if they also have a delivered status, which with tens of thousands of logs over multiple days is not working great.
I was hoping someone could help with a simple solution that counts how many items have been packed and delivered.
Thank you for any help you can provide.
Regards
Mike
First post so here goes..
I have data in 2 columns say a & b.
A b
Item log
123 packed
124 packed
123 shipped
123 delivered
124 shipped
125 packed
So I need to count the items that meet 2 criteria in column b - so say it's packed and delivered.
I've tried to filter for the packed and copy this data into a separate sheet then perform a countif on this data to see if they also have a delivered status, which with tens of thousands of logs over multiple days is not working great.
I was hoping someone could help with a simple solution that counts how many items have been packed and delivered.
Thank you for any help you can provide.
Regards
Mike