Running on Excel for mac 15.13.1 but tried on Windows 8 and failed as well! So essentially what I was trying to do is getting the average of a daily recorded data for a certain month in a certain year . I'm using the methods introduced by this website: http://excelribbon.tips.net/T010671\_Averaging\_Values\_for\_a\_Given\_Month\_and\_Year.html (Turns out that only the AVERAGEIFS approach worked. All other methods don't agree with me. INCLUDING the first SUMPRODUCT one.) The database I have is one column of date (MM/DD/YY) and another with the daily value . I'll still go with sum divided by count; the only change is that sum and count would contain SUMPRODUCT whose array1 and array2 are going to be both logical test (MONTH() and YEAR() followed by "= ") results. Always giving me warning messages of "#DIV/0". Because somehow SUMPRODUCT of logical tests results is 0??!! I did a little experiment on a separate excel file with a smaller database and stepwise. See the screenshot attached. Multiplication of TRUE and TRUE can get to 1 and manually doing what SUMPRODUCT does can get to 2 but when using SUMPRODUCT to do it in one step, it gets 0 again.

Anyone has met similar problems? Would appreciate any help or advice! :)))) A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data. Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. Not sure I am reading the problem correctly. Does this screen shot help? 1 additional answer Anonymous 2016-02-11T00:36:04+00:00 Oh my goodness! Fast as a flash of light! It works perfectly! Thanks a trillion! I caught a glimpse of adding "-" somewhere else but did not give it a second thought! You saved my day, Sir! Have a good one! :)))) 0 comments No comments Oh my goodness! Fast as a flash of light! It works perfectly! Thanks a trillion! I caught a glimpse of adding "-" somewhere else but did not give it a second thought! You saved my day, Sir! Have a good one! :))))