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...
Worksheet1
<tbody>
LastName
FirstName
Code
ID
E
Group
Address
H
Group2
Address2
K
Group3
Address3
Smith
John
01, 03
123456
Place1
123 Main St.
Jones
Fred
06
852547
Place1
123 Main St.
Place2
345 Water St.
Place3
567 High St.
White
Barb
03, 123, 04
258787
Place1
123 Main St...
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>
Hello everybody,
I have a quite large data sets (70.000) and would like your help.
Data sets looks as follows:
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
COL1
(orderid)
COL2 (prod.id)
group1
230
group1
501
group2
1231
group2...
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...
Hello all. I'm sure this is possible but I think I may be venturing into arrays, which I don't have a lot of understanding of. I have a listbox that populates a range of values (Strings) from a sheet. Each string value has a unique value attributed to it, however there are only a handful of...
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.