ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Countif array (https://www.excelbanter.com/excel-worksheet-functions/268033-countif-array.html)

LearningHorse

Countif array
 
How can I count the cells i column A that have numbers that are more than twice as big as the numbers in column B and get the result in one single cell without using a help column?
Must I have some sort of Countif array formula?


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com