I have months in column G in numerical form, and amounts to be summed in column E. I want to find out the sum of amounts for the third quarter (months = 7, 8, 9) using an array formula: {=+SUM(IF(OR(G:G=7,G:G=8,G:G =9),E:E,0))}. The formula doesn't work, though, it is summing all the entries in column E.
Bookmarks