Formula that counts based on two different columns
I feel as if this has been asked before, but I wasn't able to find a formula that fit my sheet.
I'm looking to have a column that simply places a "1" if two conditions are met in two other columns.
So basically: =COUNTIFS( [Column A = 100] AND [Column B =100] then place a 1.
There are a few other criteria's that need to be met too, like if the columns are specific to the @ row, and if they are all within the same week #, but I keep getting a zero.
So far, I have:
=COUNTIFS([Column A]:[Column A], [Column B]:[Column B]@row, [criteraA]:[criteraA], false, [CriteriaB:[CriteriaB], <>"", [Assignee Name]:[Assignee Name], [Assignee Name]@row)
But it keeps coming up blank, any help on where I messed up would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!