I'm working with call center data. I have call volumes for multiple groups by date, using the TEXT function to return the day of week. Like so:
06/03/19 Mon Group1 1000
06/03/19 Mon Group2 1400
06/04/19 Tue Group1 1100
06/04/19 Tue Group2 1500...
I'm trying to get a sum by Month (from dates in row 1) and by group (in column A) using sumifs. but am stumped. suggestions?
<tbody>
A
B
C
D
E
F
1
WEEKLY
10/05
10/12
10/19
10/26
11/02
2
Group1
91
12
33
64
29
3
Group2
3
6
8
1
0
4
Group3
12
69
3
4
56
5
6
7
MONTHLY...
Hi all,
I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists.
They are:
Group1: Range $E$3:$E$15,
Group2: Range $F$3:$F$15,
Group3: Range...
What's the easiest way of me checking multiple columns between 2 worksheets?
I have two documents, both having the same columns such as:
<tbody>
A
B
C
D
1
ACTION TYPE
TIER 1
TIER2
TIER3
2
Reporting
GROUP1
GROUP4
3
Manager
GROUP2
GROUP4
4
Access management
GROUP1
GROUP3
5
so on...
Hello friends
I want to do three or more groups but I can not do it
Combines everyone
Please help me,
<tbody>
group1
group1
group2
group2
group3
group3
group3
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
</tbody>
<tbody>
</tbody>
So not sure quite what I'm asking here, but seeing if you could give me pointers? Let's say I've got a planning table like this below. I'm trying to think of a way to have a second table that will list each ToolID and a single cell that shows all the 'items' that have X for them, dynamically...
First, I am new to VBA and this is my very first time posting a question. Please let me know if I should provide additional detail, etc. Here goes… I have a worksheet (built with MS Excel 2013) with a table and graph. There are VBA checkboxes built in so the end user can make a selection to...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.