ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 381 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Solution
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