Home

countif_problem.png

Submitted by fyyzer on 1 October, 2009 - 15:31
countif_problem.png
»

Solution

Submitted by dennistaylor on 4 October, 2009 - 22:48.

This should work: =SUM(IF(E7>=Start,IF(E7<=End,1)))   as an array formula in cell G7.

Start is the range name for B7:B12

End is the range name for C7:C12

Complete the entry with Ctr+Shift+Enter and then copy it down into cells G8:G22

»