A________________B
Manager__________3
Laborer___________3
Manager _________N/A
Foreman__________2
I want to find the average of the Manager numbers. I am using Sumif to add the numbers in column B corresponding to Manager in column A, but what do I use to find the number to divide by? I need to count the number of occurances of "Manager", but only if they have corresponding numbers. Hope this makes sense. If only Countif workeed like Sumif......
Manager__________3
Laborer___________3
Manager _________N/A
Foreman__________2
I want to find the average of the Manager numbers. I am using Sumif to add the numbers in column B corresponding to Manager in column A, but what do I use to find the number to divide by? I need to count the number of occurances of "Manager", but only if they have corresponding numbers. Hope this makes sense. If only Countif workeed like Sumif......