sumproduct across sheets

Hi I'm looking for help on this formula. Tried looking for resources everywhere with no success. Please see the attached. The goal is to calculate the YTD totals of all the months for each of the the respective employees (i.e. Bob, etc) and each category (i.e. Bonus, Salary, Gross, Tax) I am...

Hi Team, I've been pulling my hair out for the whole morning trying to get this to work. You're my last hope! Column S is free text field that can contain a country name anywhere. I can get the formula to work fine when I hard-code values. wsMainData.Range("AJ2:AJ" & LastRow).Formula =...

Hi all, My name is Arth and I am having an exercise where I have to make a consolidated file of actual vs. budgeted expenses for a particular month in a year using numbers from multiple tabs that are not orderly listed. In some cases I have to get the number that I need by dividing a number by...

I am working on a project that has a sheet for each week in the year. Within each sheet is varying employee information. On the last "Total" sheet I need it to search for the ID listed in the A column in every worksheet, when found it needs to look at the L column of the same row add it together...

I am using a sumproduct array formula to calculate the cost of a course and primarily have the raw data on sheet 'Data'. However, on sheet 'List', there is a growing list with the unique code of each student and whether the cost has already been paid. Replica of sheet 'List': Contact ID...

Hello all, I've tried if, sumif, sumproduct, indirect etc and cannot find a way to do this i hope someone can help me. My Summary sheet contains a cell with the following formula =SUM(Abe:Wyn!I7) (where Abe:Wyn = 218 worksheets and identically formatted) This has worked well but now I need...

I am trying to include an additional function in this formula: =SUMPRODUCT((Dom_Counts!$B$2:$CY$2<>"")*(Dom_Counts!$B$2:$CY$2=Dom_Counts!B3:CY3)) in order to increment the row numbers by 1 each time I drag it over to the next column without changing the column references. This formula is...

Hi I'm having some sumproduct issues after having tried various countifs. Hopefully you experts can help. My apologies, I'm now on my linux computer at home and not the windows environment at work, so I will try and recreate the functions from memory, but may get them slightly wrong. <tbody>...

I have one workbook with 6 tabs. On tab 1 I have a last name, first name, some other columns with stuff in them and 5 empty columns. On tabs 2 - 6, I have a last name col, first name col and numbered data in the 3rd col. I want to fill the 5 empty cols in tab 1 with the numbered data from...