sumifs error

Hi, I have recently discovered that SUMIFS only works between two different workbooks if both workbooks are open at the same time. I've also read to get round this, SUMPRODUCT can be used. That said I can't get it working. The SUMIFS version of the formula I need converting to SUMPRODUCT is...

Hi everyone, I have a data table called "Order" in which a column of its raw data are strings of date; ie. 20191015 (YYYYMMDD). So I added 3 columns to the table to extracts its Y/M/D using LEFT/RIGHT formulas ie. LEFT(RIGHT([@Date String],4),2) is Column [M]. Then I tried to sum the amount of...

SUMIFS has given me a headache, since I can't get the formula below to work, though I'm probably just too close to the trees to see the issue. :eeek: SUMIF works fine on TT and AH alone, but when both are used with SUMIFS, only zeros are returned. What am I missing? Any help will be highly...

Hi All, I have an issue with SUMIFs. I am trying to sum up a sub group of items that use the same main component i.e. apple. However, I only want to sum up the qty leftover from the main component item such as apple that is positive with no negative values. The reason being is that the demand...

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> #D9D9D9[/URL] "]Name #D9D9D9[/URL] "]Tx #D9D9D9[/URL] "]Product #D9D9D9[/URL] , align: right"]Price #D9D9D9[/URL] , align: right"]Fees #D9D9D9[/URL] , align: right"]Total John Purchase...

Hi Guys, I have used SUMIFS many times before without any issues but cant seem to understand why it is errors out (#VALUE! error) in the following formula. All my ranges are the same size, Column K is TEXT format although not sure why this would have any impact. Column O is also in TEXT...

Hi all, I have been reading this forum for a while and always found it to be very useful! I am however now stuck with an issue I can't find an answer for... I am working on a file where 5 tabs represent 5 producers (each tab as the producer name), and in each tab, I have a standardized budget...

Hi, I have the following formula summing up a Cost field when 2 criteria_range settings are met as follows: SUMIFS(tProjectChanges[Cost],tProjectChanges[Budget Item Code],D33, DATE(YEAR(tProjectChanges[Date Originated]),MONTH(tProjectChanges[Date Originated]),1),E46) The 2 criteria_range in...

Hi I am trying to use sumfis formula to calculate total sales using OR condition. I am using dynamic ranges in the formula but I have also tried using normal range as well. Formula is calculating only one random value in the criteria range and not all of them. Formula is here...

SUMIFS ignores errors and just returns 0, how to return N/A ? IFERROR won't work, countif also didn't help. IF 0 then N/A - not applicable, as I also have some actual zeros, that I need. <tbody> City Country Provider Sum A XY Apples 200 A XZ Apples 100 </tbody> Table where I look for...

I made the following formula to automatically update a report to return Day, Week or Monthly values based on Cell B2 (Which changes based on user input from userform) =SUMIFS(Qty,Custodian,$B10,Defi,"Active Others",Age,C$4,Method,"Electronic",Rec_Rej,$C$3,day,$A$2). The columns have defined...