array formula
How can I re-write the code below so that it finds the
data for F14:F1403 that is between 100000 and 200000? SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)* ($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)* (F14:F1403199999)*($C$14:$C$1403=$B$6)) |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com