Posted similar yesterday and have updated what I'm looking for.
===========
I'm using this formula =COUNTIFS(RevenueALL!$B:$B,Sheet4!$C12, RevenueALL!$H:$H,$C$2,RevenueALL!$P:$P,">0") and it does indeed do what it's being asked to do.
I need some help with evolving it. In addition to what it's looking at, I need it to look in RevenueALL!$C:$C and report how many unique entries there are that meet all other criteria in the formula.
Thank you in advance
===========
I'm using this formula =COUNTIFS(RevenueALL!$B:$B,Sheet4!$C12, RevenueALL!$H:$H,$C$2,RevenueALL!$P:$P,">0") and it does indeed do what it's being asked to do.
I need some help with evolving it. In addition to what it's looking at, I need it to look in RevenueALL!$C:$C and report how many unique entries there are that meet all other criteria in the formula.
Thank you in advance