Good Day Expert,
I have a MS Excel 2010 workbook (attached) with two spreadsheets CSWGROUPLISTING033115 and GroupMemberCount in which I wanted to match the totals from GroupMemberCount to CSWGROUPLISTING033115. I am using the sum product function but am having some problems.
I searched the two spreadsheet and the groups do show in both spreadsheets but is returning says 20 plus 1 or 21 when the total should be 20. Also there will be total that return 1 but when I searched in the GroupMemberCount the group number cannot be found.
I highlighted a couple example in the spreadsheet attached. Could you please let me know what I am doing wrong?
Please see the funtion - =SUMPRODUCT((GroupMemberCo