Hi there, some wonderful people have helped me here before, so asking politely once again.
So I have a number of people who must take certain actions when they receive an email. Column one is peoples initials, column two are the actions. Eg. I want to search for HW, and count how many occurrences of 'Notification in, await report'. I'm trying: =IF('[Email Report.xlsx]RD '!$G$2:$G$71*("HW"),COUNTIF('[Email Report.xlsx]RD '!$J$2:$J$73,"Notification in, awaiting report")) There's clearly errors there so any help would be very much appreciated thank you.
So I have a number of people who must take certain actions when they receive an email. Column one is peoples initials, column two are the actions. Eg. I want to search for HW, and count how many occurrences of 'Notification in, await report'. I'm trying: =IF('[Email Report.xlsx]RD '!$G$2:$G$71*("HW"),COUNTIF('[Email Report.xlsx]RD '!$J$2:$J$73,"Notification in, awaiting report")) There's clearly errors there so any help would be very much appreciated thank you.