EXCEL PRO TIP: Counting Matches with SUMPRODUCT

[@wayneedmondson1065]

Hi Chris.. thanks.. great video. SUMPRODUCT and COUNTIF are powerful. You might want to mention the use of F9 key to evaluate and view the array components as you edit the cell. Sometimes, I find that easier to audit vs. the Evaluate Formula dialog which is pretty small.. don't understand why MS does not allow user to expand that dialog size to see more easily. Anyway, matter of preference. Thanks again and thumbs up!

[@ExcelMaven]

I always forget about the F9 shortcut for evaluating formula components -- good idea for a follow-up tip!

[@ubaidillahmuhammad20]

nice. put excel file in the video description .....