IF/THEN formula with multiple conditions?
What I need is a formula that I can apply to 6 different conditions. So I need it to be if Test condition = TC1 and exposure condition = EC1 then it goes to a specific part of the spreadsheet, etc. (determined by those preset conditions, as the Test condition determines where there is data as otherwise it is blank) and then count the number of “yes“. I want this to be a formula I can include all 6 potential combinations of test condition and exposure condition so I can have it do this automatically for each line of data. I tried a COUNTIFS formula but that just returned a #VALUE! error. I was thinking I could just spaghetti code the formula with a combination of COUNTIFS, COUNT, and IF but I was wondering if there was a more elegant solution. Sorry if this is not well explained I am happy to clarify anything that does not make sense.
[link] [comments]
Want to read more?
Check out the full article on the original site