Countif, Based On Result Calculated From Values In Multiple Ranges
Rate this:
(3/5 from 1 vote)
I have two separate ranges on a spreadsheet. In range A5:A20, there are some numbers. In range H5:H20, there are other numbers. Suppose I did a calculation like this (for each row): =A5+(H5*0.6). Then further suppose that I wanted to countif the resulting value was greater than 38.5 - this is what I want to use the countif or countifs function to do. Of course, I could set up another range, say J5:J20, to perform the calculation above and then use this formula: =COUNTIF(J5:J20,">38.5"). However, I don't want such a column to appear. I would prefer to simply write a formula that can give me the answer in one hit. Any way to do it?
Posted by Dave P on
There are currently no replies to the "Countif, based on result calculated from values in multiple ranges" topic of the Excel Help Forum for Analyzing Corporate Financial Data.
Find relevant Excel templates and add-ins for Countif, based on result calculated from values in multiple ranges in the Excel Business Solutions Directory
