exceljockey
Member
HI
I am currently working with a database which has a bunch of different columns: http://i.imgur.com/WXiV1D1.png
Now I need to count how many jobs were received, under two conditions: Month (col 6) & Site_Code (col 3).
I did a simple countif to count how many jobs were listed under these two conditions, however, each job is split up into multiple rows under one certain Order ID (col A). So my current forumlas pick up too many jobs as its just counting how many rows under the two conditions, and isn't adding the multiple rows under the one order ID.
How would I make it so that it picks up only unique order IDs under the two conditions previously stated?
E.G. Rows 22797 - 22801 is all one Job ID but the countif formula would list it as 5 different jobs (obviously).
I Have looked into countif for uniques, but I really don't understand how this works, so would like somebody to elaborate!
Thanks
EJ
I am currently working with a database which has a bunch of different columns: http://i.imgur.com/WXiV1D1.png
Now I need to count how many jobs were received, under two conditions: Month (col 6) & Site_Code (col 3).
I did a simple countif to count how many jobs were listed under these two conditions, however, each job is split up into multiple rows under one certain Order ID (col A). So my current forumlas pick up too many jobs as its just counting how many rows under the two conditions, and isn't adding the multiple rows under the one order ID.
How would I make it so that it picks up only unique order IDs under the two conditions previously stated?
E.G. Rows 22797 - 22801 is all one Job ID but the countif formula would list it as 5 different jobs (obviously).
I Have looked into countif for uniques, but I really don't understand how this works, so would like somebody to elaborate!
Thanks
EJ