I have an AVERAGEIFS statement that I need to take two different criteria on one range. From the looks of it on Microsoft's site, I should be able to do it. Yet when I try it, I get the good ol' #DIV/0! error.
The statement is as follows (they way I thought it would work, anyway):
=AVERAGEIFS(J:J,F:F,"Inactive",D:D,"Equity",D:D,"Fixed Income")
...It works fine if I only have one of the D column criteria (either one of them), but not with both. Can I not put multiple criteria on the same column range in an AVERAGEIFS? If not, could someone please suggest another way of doing this. I basically need to get the average of the values in the J column of all rows left after those three criteria are met.
Thanks in advance!
Bookmarks