Forum Discussion
Count cells with positive values - advanced
Hi, I need a formula that will find the last three cells minus one cell in a range containing positive values only. The formula needs to be dynamic as more cells are added to the range. Do le...
Is there anyone who can help me with this?
The formula provided needs to be dynamic to be of any use because new data is added parodically to the row of data.
The formula provided needs to be dynamic to be of any use because new data is added parodically to the row of data.
=COUNTIF(INDEX(E6:ZA6,LARGE(IF(E6:ZA6<>"",COLUMN(E:ZA)-4),4)):INDEX(E6:ZA6,LARGE(IF(E6:ZA6<>"",COLUMN(E:ZA)-4),2)),">0")This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
