Monday, July 16, 2012

yogi_Compute Sum Of Amount Spent For A Specified Category In A Specified Month

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #632   Jul 16, 2012

user tranqui said:(!category-topic/docs/spreadsheets/b-rfaB1Yedw)
Formula Error #NUM! 

I have been using this for month in a speadsheet. Recently it is giving me an Error #NUM! Argument is blank. I don't understand why this has stopped working.
there has recently been a change in how Google spreadsheet handles date and time related elements for blank cells -- use of IFERROR function should take care of the problem in your case. You also have a redundant INDEX function call in your formula.
I have also generalized the solution for looking at the SUM by a specified month