Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
conditional average
what would be the formula to calculate conditional average, i.e. if conditions a,b, and c are met then average the rows x1:x40? I used average and if functions in an array formula and it did not accept all the conditions. The results displayed were not consistent with pivot table results.
Show All 1 Replies
Login to Reply
0
by Guest 1.
added 10 years ago
