Using COUNTIFS with Excel 2003
Excel 2007 introduced the function COUNTIFS to count cells based on multiple criteria. For example suppose you wish to count how many times the client Fowler buys more than 250 shares. The answer for tha data below turns out to be 2 using the Countifs function entered in B13. Similarly for Owen the result turns out to be 1. […]