hi i currently have this formula that counts the number of times a cell in a range is above 0 and returns a value x 25...
=COUNTIF(BQ25:CM25,">0")*(25)
how do i set up the formula so i can check a different range but return the values from bq25 to cq25.....
if bq30:cq30 are greater than 0 then count bq25:cq25 and x by 25
Thanks
=COUNTIF(BQ25:CM25,">0")*(25)
how do i set up the formula so i can check a different range but return the values from bq25 to cq25.....
if bq30:cq30 are greater than 0 then count bq25:cq25 and x by 25
Thanks