Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup, sumif, if, countif, help
Hi Mangesh, The formula is not working for me, ok i will explain u properly in a different form. Time ACD Calls Name Totals 6 a1055 7:00 7:30 AM 0 7:30 8:00AM 0 8:00 8:30AM 0 8:30 9:00AM 0 Column A will have Agent ID, Column B and C will have Timings say 7:00 to 7:30 and so on (hourly count) and Column D will have no of Calls taken. Now I want to add the count of calls between 7 to 8, 8 to 9 and so on. Now the trick is that whenever i write a formula it should look at the column A having unique ID and then return the total of count in one hour in the column E. How is it possible, if you have not understood then i shall explain you again -- chintu49 ------------------------------------------------------------------------ chintu49's Profile: http://www.excelforum.com/member.php...o&userid=18631 View this thread: http://www.excelforum.com/showthread...hreadid=372177 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
How to combine a vlookup with a sumif function!!! | Excel Discussion (Misc queries) | |||
SUMIF using VLOOKUP as criteria | Excel Worksheet Functions | |||
Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
Countif, Sumif, If - help! | Excel Worksheet Functions |