sumifs with and/or

Akk Help Ok my sumif formula works fine (List!B3:B14,AC4,List!D3:D14) returns the proper value, now I need to add two additional criteria to that so if B4 = "V" and if AD2971 >= 91 then I need it to return the value from the sumif and of course return a blank if the criteria are not met...

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

Hello, Thank you for taking time to read my query/challenge?? I have been having a mental blank for the last two evenings on this and decided to ask you wise people for help. The question summary is at the end. Sorry it is long, I have just tried to add as much detail as possible. I have the...

Hello all :) I'm running into an issue where I'd like to use a cell reference as input into a sumifs function. The cell reference will contain an numeric entry, and will have between 5 to 10 entries (in separate cell references). Let’s say the cell references I’d like to have in the formula...

I was wondering whether it is possible to incorporate multiple criteria in a SUMIFS formula. I have a form control dropdown box with various items in it that have been linked to a list of cells within the spreadsheet. So my dropdown box has, for example: Item 1, Item 2, Item 3, Item 4, All...

I hope someone can help me. See table below. <colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD 2011 100 100 0 100 200 200 0 100 100 200 100 100 700...

Please help! I am trying to get a formula to keep a running cumulative total at the end of a row, but only if the row below is populated. See example below A B C D E F Row1 100 0 200 100 100 =300 Row2 100 200 100 =400 D2...

Can an OR function be imbedded in a SumIfs function? For example, I want to do a SumIfs with two criteria, however the second criteria could be 3 different values. For example, Column 1 = department number Column 2 = expense category Column 3 = data to be summed I want to sum all data in...

Hello, Here is what I have : A B 2 - 4 5 5 - 6 7 What I need to do is a sum of the column A if <>#N/A" and "<>#DIV/0! And In case the cell value B is not blank, replace the value in the corresponding A cell with the B cell value In this case A column sum is 17 the sum I want is 19 Could...

Hi all, I'm creating a report that uses pulldowns to let people select various groupings of products. So e.g. it will have a pull down for state listing out all of our states, but then will also include groupings of states, "west region" "east region" "all" I would like to create a sumifs...