TheoKhalid
New Member
- Joined
- Dec 30, 2019
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
I have the table below and I want to find out how many times each item in column F, "Manufacturer Part #" is used on each machine. The "Machine #" is listed in column G. I am using the "countifs" statement;
"=COUNTIFS(F:F,F3,G:G,"5201 - Electrical")"
but it gives me a 1 even for the rows that have "5202 - Electrical" in column containing the machine #.
My understanding is that when you select the entire Column, excel checks if criteria is met in rows corresponding to the cell in which calculation is being done.
Example; if the above formula is used in column J3, then the execution will be as follows:
Check entire column F if it contains the value in Cell F3, if true then,
Check entire column G if it contains the value "5201 - Electrical", if true then count goes up by 1.
Issue: why is it returning a 1 for machines that are not "5201 - Electrical".
Any and all help is appreciated. Thank you.
"=COUNTIFS(F:F,F3,G:G,"5201 - Electrical")"
but it gives me a 1 even for the rows that have "5202 - Electrical" in column containing the machine #.
My understanding is that when you select the entire Column, excel checks if criteria is met in rows corresponding to the cell in which calculation is being done.
Example; if the above formula is used in column J3, then the execution will be as follows:
Check entire column F if it contains the value in Cell F3, if true then,
Check entire column G if it contains the value "5201 - Electrical", if true then count goes up by 1.
Issue: why is it returning a 1 for machines that are not "5201 - Electrical".
Any and all help is appreciated. Thank you.