Afternoon.
Im currently looking to obtain two different types of data on a COUNTIFS formula, I also want this to be an indirect formula.
The data as follows, the "Acc Feedback" is a data val list, I would like the indirect formula to look at the date (August 14 - all the data I need is stored on a tab with the same name) and the RE basket (Acc Feedback) and the advisors name. Then return all values, basically in this scenario I would like all instances of Acc Feedback for Paul Thomas in August 14.
Can this be done, thanks for reading. I understand this might be abit confusing.
<TBODY>
</TBODY>
Im currently looking to obtain two different types of data on a COUNTIFS formula, I also want this to be an indirect formula.
The data as follows, the "Acc Feedback" is a data val list, I would like the indirect formula to look at the date (August 14 - all the data I need is stored on a tab with the same name) and the RE basket (Acc Feedback) and the advisors name. Then return all values, basically in this scenario I would like all instances of Acc Feedback for Paul Thomas in August 14.
Can this be done, thanks for reading. I understand this might be abit confusing.
August 14(List) | |
Acc Feedback(List) | |
Paul Thomas | |
<TBODY>
</TBODY>