SUMIFS across multiple worksheets

**JNAllen1990** · 03-17-2015, 11:44 PM

I'm trying to create a formula that sums the values in cell B6 from sheet Calvin Scott:New, but does not sum the cells in B6 when there is a letter 'T' or 'O' in cell D6 on any one of those sheets.

I'm trying to combine all the data from a certain day on the sheets into one cell, but exclude values where a certain variable occurs in D6.

I included an attachment of the file for better understanding. Alternatively, there is a tab called 'Today' that has the data I am ultimately trying to present (the Actual TONS in cell C24 on the 'Today' sheet) but I can only gather it when I change the date in cell A1. If there is a way to record the Actual TONS in a column on Sheet1 for each day that is typed in, this would be ideal.

Raw Materials Production Log (FEB).xlsm

**FDibbins** · 03-17-2015, 11:59 PM

Hi, welcome to the forum

1st, please try and avoid using merged cells, they cause all sorts of problems with formulas.
2nd, what exactly do you need help with - and where?

**JNAllen1990** · 03-18-2015, 12:04 AM

Thanks!

The forumula I tried initially =SUMIFS('Calvin Scott:New'!B6,'Calvin Scott:New'!D6,"<>T",'Calvin Scott:New'!D6,"<>O") gave a #value error. I'm new to excel and have so far been able to kinda reverse engineer other formulas I've had issues with based on older threads, but I'm really having trouble with this one.