How can I use this function on Excel 2003??
D Dave Peterson Mar 2, 2009 #2 Try: =sumif()/countif() How can I use this function on Excel 2003?? Click to expand...
S Shane Devenshire Mar 2, 2009 #3 Hi, the AVERAGEIF function was introduced in 2007, you have to use an alternate method. You have one, here is another, using an array: =AVERAGE(IF(test,"",B1:B7)) to make this an array press Shift+Ctrl+Enter, not Enter to enter it. Enter your "test"
Hi, the AVERAGEIF function was introduced in 2007, you have to use an alternate method. You have one, here is another, using an array: =AVERAGE(IF(test,"",B1:B7)) to make this an array press Shift+Ctrl+Enter, not Enter to enter it. Enter your "test"
