I have a spreadsheet, called To Do, with set of percentages in column E and importance levels in column A:On another spreadsheet, I'm entering a formula to calculate the average of these percentages, but only those between certain importance levels:See it on googledocsThis is the formula in question, indented for easier reading:=TO_PERCENT(     DIVIDE(         SUMIF('To Do'!A3:A, <2000, 'To Do'!E3:E)        - SUMIF('To Do'!A3:A, <=1000, 'To Do'!E3:E),          MAX(             COUNTIF('To Do'!A3:A, <2000)            - COUNTIF('To Do'!A3:A, <=1000),              1         )     ) )Is there any better way to do this?I originally wanted to use SUMIFS and COUNTIFS, but it said:error: Unknown function name
Averaging a set of percentages between certain important levels
excel;google sheets