Indirect Countifs - Please Help.

faintxyz

New Member
Joined
Aug 13, 2014
Messages
3
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.

August 14(List)
Acc Feedback(List)
Paul Thomas

<TBODY>
</TBODY>
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,109,322
Messages
5,528,007
Members
409,798
Latest member
Snake68

This Week's Hot Topics

Top