Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Need to get total sum of events raised by each individual

0

Hi,

Could you please hlep me in getting the details am looking in for. In sheet1 i ahve issue numbers and the Engineer who raised the issues. in sheet 2 i need the total number of issues  by the eniggneers based on Coloumn A ( not sure on how to use wildcard to get).  Happy to provide more details, find the attached.

excel
posted by: Ravula (rep: 2) on Tue Aug 8, 2017 at 2:59 pm
Answer
Discuss

Answers

1
Selected Answer

Try this file

posted by: salim_hasan (rep: 40) on Tue Aug 8, 2017 at 4:02 pm
Discuss

Discussion

Hi,

Thanks for the quick response, but when am trying to use the formula from the sheet you gave i am unable to see "{" at the first and end of the formula. i tried copying it but aint got any luck. could you please help me out.
Ravula (rep: 2) Aug 9, '17 at 12:40 pm
Hi Salin,

i have added the original sheet which am working on, could you please check the Tab "Agent Wise" where am trying to incorportate the formulas you gave to me. 
Ravula (rep: 2) Aug 9, '17 at 12:43 pm
you must use (CTRL+SHIFT+ENTER) with the formula 
after you type it press (CTRL+SHIFT+ENTER) not (ENTER )Only
BECAUSE IT IS AN ARRAY FORMULA
salim_hasan (rep: 40) Aug 9, '17 at 12:51 pm
Hi Salim,

Thanks for flying respone, as said am very very new with Excel formulas as am in to netwroking domain. I tried but somehow its showing only "0" in the table. Maybe am missing something or confused with the Rows and coloumns. Apologies for the inconvenice, if you could help me to update the same in the latest attachment that will be really helpful for me. could you please update the test 2 sheet . Waiting for your reply on this. Thanks again for getting back.
Ravula (rep: 2) Aug 9, '17 at 1:57 pm
Gyus could anyone please help me out!!
Ravula (rep: 2) Aug 9, '17 at 3:29 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login