sumifs need help

Hello Everyone, I have following table and need help on sum total of Value 1 column. Value 1 Value 2 100.00 100.00 200.00 500.00 300.00 300.00 400.00 100.00 I am looking for a formula which would return value based on the following criteria: If Value 1 = Value 2 then exclude that...

I use sumifs very regularly and have recently came across a situation that one of the criteria used will in some cases be blank and some case have data. Is there a way to build into your sumif ignore if isblank?

Hi all, I am attempting to clean-up one of my dashboards by linking it directly to the source data rather than via an Access database. I have hit a problem with #Value errors from a SUMIFS formula. I have found from reading many threads that this function is not compatible with closed...

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...

Hello, I am using a Google Spreadsheet to calculate total number of gift certificates sold by year AND (ideally) by gift certificate type (2 types: full or partial). An example spreadsheet with fake data is here...

I'm trying to us both sumifs and countifs to gather various information on a set of loans. I'm wanting to look at the year the loan was originated as one of my criteria in these statements, but the dates are stored with the actual date. I find that sumifs and countifs are generally MUCH...

Hi All! I am new to this forum and I am also rather new at Excel! I am trying to use a formula that will calculate the below: If in column A, a date in December appears, tell me the total amount of column C, if the amount is greater than 0 This should then calculate the total expense for...

Hello! I'm trying to play with numbers (Excel 2010) from counting elk that crossed by a game camera. When using the SUMIFS function to categorize data by month (elk counted in February, March, April, May), the values given by my April and May formula are off by 1 compared to the value given by...

Hey Mr. Excel, i could do with a bit of help here. I got 6 criteria for different product grade in total and some of the criteria fields are blank because we don't have a particular grade for those products. Obviously, i opted in for SUMIFS function but it turned out sumifs cannot handle blank...

Hi, I wanted to ask if there is a way to use a SUMIFS with a criteria set that can “vary”??? Need to “SUMIFS” with multiple factors (DATE, ROOM NUMBER, ROOM USED FOR, etc) such that the ROOM IS USED for either ALL TYPES OF PROCEDURES(ELECTIVE, URGENT, EMERGENT, Add-On), ELECTIVE ONLY or...

Hello, I have a big spreadsheet with IT / Finance data. Below is the formula, I currently have. I am summing column Y in Tab Savings Data Detail, where column A does not equal Parent, and The Value in Column AK on the Savings data details tab matches the value in current tab for cell B26...

Hi All, Again I am here and need some help from u guys. I have a data in the below mention format. <tbody> Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 70889 145435 146441 497470 194199 448098 432087 388909 1392 367637 254906 378658...