sumproduct?

Hi, I have the following as an example of the data that I am working with. I am trying to get a formula that allows me to select the year, week number, and shop, and also allow me to dynamically select the sales (Beer or Wine or Spirits) and then sum them over a period that I define e.g. I...

I want to count the number of events are taking place on each day over a 2+ year period. We have the start and end date for each event and there are almost 2000 events. In essence, I think the criteria range essentially becomes in this case A2:B5, and we're looking counting the number of times a...

Hi, I'm trying to match multiple cells of data to a table. I figured out (using other threads) how to get one set to match another, but am trying to figure out how to get multiple sets to match in different orders without spelling them each out. In the end I'm looking for the name that will...

I am trying to put together a reference document: Below is a simplified version: <TABLE style="WIDTH: 415pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=552 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 15pt; mso-width-source: userset...

Hello. Forgive me if this has been answered elsewhere. I have looked but I'm having difficulty matching my situation to others. Or perhaps I'm just not understanding how to use COUNTIF/COUNTIFS/SUMPRODUCT. Here's my situation: I'm hoping to create a matrix that displays the number of Home...