sumif another worksheet

I have two formulas that work perfectly but I want to add another if (I think) element to the formula. I have just got a small sample of data and based on the small sample its not worth trying to find a short cut but when you have 100 data sets and 500+ rows of data. So what I am wanting is on...

I have made a formula which corresponds to certain components. I need to make this formula for each day of the year for 9 components, using information from another worksheet in the file. However the cell range is from e.g. 1:23 for the second day it is 24:47, so forth. I cannot drag this...

Hi, Beginner Excel user here.... I have a summary sheet that I'd like to use to show me how many items have been sold in each Farm for a specific time frame. I understand that SUMIF won't work because my range is a column but my sum_range is a row. The criteria has to be Item Code (Column A)...

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'm struggling to make the following formula dynamic and be able to change the cells if references. I have this formula which works fine: =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets!$C$1:$AM$1&"'!A:A"),$A4,INDIRECT("'"&Sheets!$C$1:$AM$1&"'!"&C$1))) However in sheet 'Sheets' I may not always want...

I've worksheet "summary" & "ExpLedgers" ExpLedgers having 8 columns The 8th no. column i.e. column H having Ledgers GroupCode I want sum of 6th column (Column F) to store in variable DataArr(R1, 1) --> Group code store in this array e.g. here it is 16 for this I use following function...