Adding totals that occured during a month from a list

[sugar824]

I am trying to get a count by month of the people who are invited to seminars and who shows, rsvps, and doesn't show etc. I'm attaching a new sample with the new tab seminars and then the hoped for result grid on the metrics tab. If anyone can help me with this I would appreciate it.

Based on the tutorial you linked for me previously, I feel like a sumproduct could be used again. But again I seem to be lost when trying to pull the "month" out of the date. I suppose I could set the date up in 3 cells making day, month, and year 3 different columns, but that feels clumsy.

[jeffreybrown]

First things first...

B17 through B21

• Change those cells to 1/1/2017, 2/1/2017, 3/1/2017, etc.
  Then apply a custom format

Data Range

	B	C	D	E	F
16		Invited	RSVP'd	Attended	No show
17	Jan	305	240	266	39
18	Feb	261	204	233	28
19	Mar	386	329	363	23
20	Apr	0	0	0	0
21	May	0	0	0	0

Custom Format

• Right click cell/s (or Ctrl + 1)
• Format Cells
• Number
• Custom
• Type: mmm

Now paste in C17 across and down... =SUMPRODUCT(--(MONTH($B17)=MONTH(Seminars!$A$2:$A$10)),Seminars!B$2:B$10)

[sugar824]

That worked perfectly. I think now seeing the first Sumproduct and this one, I get it. So in the first one you helped me with we did the double unary on both to get a logical multiplication where when both are true 1*1 gives us 1 and it counts them. Where as in the second the first is turned into a logical 1,0 and the second is left alone so if true it gives me each number back and adds but zeros the others.
Thank you for helping with this. I will add these to my long list of learned things for future projects.

[jeffreybrown]

Thank you for helping with this.

You are very welcome and your explanation sounds spot on. Best of luck with the rest of your project.