Hello,
I am using the below formula(which is working fine):
=AVERAGEIFS(HRD!$K2:$K10081,HRD!$I2:$I10081,J$4,HRD!$H2:$H10081,J$5,HRD!$F2:$F10081,A7,HRD!$L2:$L10081,$A$1,HRD!$C2:$C10081,$C$2,HRD!$B2:$B10081,$D$2,HRD!$L2:$L10081,$A$1)
Now, how can I include into this formula above, another condition like IF NOT IN "P4". The P4 data is in HRD!$J2:$J10081.
Thanks!!
Is P4 a cell address or is it a value within the group of HRD j2:j10081?
if it is a cell address I would think you could add in the condition =AVERAGEIFS(HRD!$K2:$K10081,HRD!$I2:$I10081,J$4,HRD!$H2:$H10081,J$5,HRD!$F2:$F10081,A7,HRD!$L2:$L10081,$A$1,HRD!$C2:$C10081,$C$2,HRD!$B2:$B10081,$D$2,HRD!$L2:$L10081,$A$1,HRD!$J2:$J10081,"<>"$P$4)
or adjusted. (Honestly never used this function but I would think it works like the other ifs functions based on how it is written.)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thanks Sambo kid, it worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks