=AVERAGEIFS(Activity!K2:K80,Activity!A2:A55,"Complete",Activity!C2:C62,"Oakpointe")
K2:K80 holds dollar amounts. I would like the average of those dollar amounts where Column A=Complete, and Column C=Oakpointe
For some reason it won't return the average. Could it be because Column A can C are dropdowns?
Last edited by katja328; 04-08-2009 at 06:20 PM.
The ranges need to be the same size...
=AVERAGEIFS(Activity!K2:K80,Activity!A2:A80,"Complete",Activity!C2:C80,"Oakpointe")
Duh....Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks