Hi NARAYANK991. I have done the two separate SUMIF statements with a plus sign and got the correct answer. I am used to using SUMIF and I thought could this be done using one SUMIFS statement but I see from what you are saying that it cannot be done. So I will stick with using SUMIF. Thanks
Hi, the following is the formula used and I have included ten amounts in A2 to A11, you should get $9800 as the correct answer....
=SUMIFS(A2:A11,A2:A11,"<"&300,A2:A11,">"&500)
$500,
$1000,
$200,
$600,
$1200,
$100,
$5000,
$1700,
$400,
$500
Hi, I tried both your SUMIFS formulas and still get zero for both. When I do the single SUMIF for 300, I get the right answer..it just doesn't work out when you combine the 300 and 500.
Hi, I have a column of salaries with the data starting in A2 to A200
I need to sum the salaries less than $300 and greater than $500.
I can do a SUM in an Array and get the correct answer but I want to do a SUMIFS statement, if possible? I have tried the following but I get zero as the result...
Hi, I am an intermediate user of Excel 2010 but this is a really basic question for which I cannot find any information about . I have never used the Custom properties tab found within “Info, Properties, Advanced Properties. Can someone please explain why you would use the dropdown fields of...