Hi all, this is my first post, and I would be very grateful if anyone can help me solve this issue.
I have set up a spreadsheet in Excel 2010 that is fully working, but I am looking to migrate to Google docs so I can have a live update on Ipad and PC.
I am aware SUMIFS does not work on Google docs, and I think SUMPRODUCT is what I need to change it to, however I cannot get it to work.
The formula I have in Excel is =SUMIFS(Income!$G:$G,Income!$B:$B,">=01/04/2013",Income!$B:$B,"<=30/4/2013") where G is the amount in £, and B is a specified date. I am essentially looking to total monthly income, and I will have a similar formula for expenditure on a different sheet.
If anyone can shed some light on an alternative formula that is compatible with Google Docs, that would be brilliant.
Thanks
James
Bookmarks