Here goes
I have three columns of data I want to have the computer to tell me how many fans I have from a certain location.
example: B 1 Fan
B 1 Boot
c 1 Fan
B 1 Car
B 1 Fan
I can use a countif statement to tell that I have three fans but, I want something that will tell me how many fans do I have that are from the B location in column a. and then how many boot from the b location etc...
Thanks
I have three columns of data I want to have the computer to tell me how many fans I have from a certain location.
example: B 1 Fan
B 1 Boot
c 1 Fan
B 1 Car
B 1 Fan
I can use a countif statement to tell that I have three fans but, I want something that will tell me how many fans do I have that are from the B location in column a. and then how many boot from the b location etc...
Thanks