sumifs across tabs

I am trying to sum total work hours by week according to the current date, on multiple sheets. But my first line of code throws an error despite working as a formula on the spreadsheet itself. Next week, week 3 and week 4 work perfectly fine but when I try to sum for the current week the macro...

Hello Sheet 1 Sheet 2 In sheet 1, I need to know how many times each SMT has someone absent with 1 occasion, 2 occasions, 3 occasions and so on summed from sheet 2 So, using the above examples, Bob would show In the above example sheet 2, I've collapsed some columns to protect private...

Good Moring All! I am looking to reference a separate table on a separate worksheet in the same workbook. I would like to total all hours worked for one specific job code in the table. The formula is below: What am I missing? Too few arguments...

I have a summary page with people's names and I am summing up their sales from a given month (worksheet Jan, Feb, Mar, etc.). In those months there are one or more sales recorded in a row. But for some reason starting in the month of May and only on a few select people it no longer gives a sum...

Hello everyone, I'm trying to put together a sumifs condition working with (2) criteria across (12) tabs, but I'm getting a #REF!. =SUMPRODUCT(SUMIFS(INDIRECT("'"&M1:M2&"'!$S$2:$S$67"),INDIRECT("'"&M1:M2&"'!$F$2:$F$67"),B$1,INDIRECT("'"&M1:M2&"'!$C$2:$C$67"),$A2)) In essence, M1:M2 would be...

I keep running into errors trying to solve this formula. I am needing to have E8 total up several cells with possible IF variables (not sure it IF is even the correct choice). Plus this type of calculation is way above my level of knowledge in Excel. I am pulling data for this formula from two...

I have a table in excel. The table has dimension as Country, City, Zip code and sales person, I want group by them by in row by sales value and QTY and in the column the Year and corresponding period should reflect. Values in the cells will be sum of rev by period and then again sum of qty by...

Hi I am trying to consolidate multiple sheets into 1 tab. I don't know how to use the sumif because 2 of my criteria are in the same column: the customer name and the value name. I don't even know exactly what formula to use...all help would be appreciated. I am trying to consolidate data in...

I'm working on a company project where I've been asked to use the sumifs function. The issue I got is that I need to combine multiple sheets with different criteria. At this moment, all I've is a Master sheet where I've details about the columns of different worksheets, and the other 3 sheets...

My Task is to Summarize the Ingredients By Categories. I have two Worksheets/Tables. The First lists the Categories and their respective Recipes CategoryRecipe <tbody> Category (A) Recipe (B) Cat1 RecA Cat1 RecB Cat2 RecD Cat2 RecC Cat3 RecA Cat3 RecD </tbody> Next is the...

Hey guys, I'm facing a rather tricky issue: I have two data sheets and one output sheet. Sheet 1: <tbody> Customer-ID Entry Date Exit Date Match-ID 123 01. January 2016 06. May 2016 333 234 15. April 2014 23. December 2015 444 ... ... ... ... </tbody> Sheet 2: <tbody> Customer-ID...

Hi all, I am completely stuck with how to get around my spreadsheet problem. I have a simple example of what I am trying to achieve listed below. Sheet 1 'Product Unit rates per Customer' is a list of Products in column A and the different individual customer rates per product to be calculated...

Hi there, I am in need of help with a SUMIFS function I'm trying to use. I am trying to sum the total quantity of products sold in a column if it matches the SKU and date in the corresponding column. In this first image you can see the function: Sheet 1: https://postimg.org/image/xi73c6fij/...

So basically I'm trying to add the amount of phones sold each week for each employee for their commission breakdown. So I have Commission Breakdown as the First Tab and Sheet1 (which is exported directly from the POS) which is the phones sold So in CB Tab I have a From date (A6) and a To date...

Hi all, First post so hopefully going about this right. I've searched a bunch of the threads but can't seem to see what I'm doing wrong. Help would be appreciated. - I have a table (Customer_Table) in cells A3:A12, with a list of customers. Each one has a corresponding tab name in the...

I have created a named range that goes across multiple tabs. The range name is associated with a string that looks like this: ='Customer Retail:Customer Retail (END)'!$A$5:$X$5000. I need to either create a table on a separate sheet that includes all of the data from this range so I can then...