SUMIF Two Conditions
On Oct 5, 3:49 pm, Dave Peterson wrote:
I didn't notice that portion. But glad you got it working. Just a note--did you really want to excel 12/31/2008 from the criteria? MJones wrote: Hi Dave, Let me apologize for posting this 3 times. Something strange is going on with Google Groups and none of my groups are showing any postings beyond October 3rd, including this one. I had to come into Microsoft's website to find this, which I'm glad I did. Anyway, thanks for your formula. It worked great, but I don't know if you noticed that I added a second part to say if the date falls within a range. For those interested, I got it working like this: =SUMPRODUCT(--($B$5:$B$59DATE(2008,9,30)),--($B$5:$B$59<DATE(2008,12,31)),--($D$5:$D$59=C69),$F5:$F$59) Thanks again for your continued support. You're great! Michele P.S. - Is there a simple explanation for those double dashes or somewhere I can read about them? "Dave Peterson" wrote: =sumproduct(--($b$5:$b$59<date(2008,9,30)),--($d$5:$d$59=c65),$F5:$f$59) Adjust the ranges to match--but you can't use whole columns (except in xl2007). =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html mjones wrote: Hi All, This doesn't work: =IF($B$5:$B$59<39721,SUMIF($D$5:$D$59,C65,$F$5:$F$ 59)) - entered as Ctrl-Shft-Enter I'm trying to get a total amount in column F if the date in column B is less than 39721 (30-Sep-08), and column D matches C65. Then I need the same thing, but with the date within a range, e.g. $B $5:$B$5939721<39813 ... I hope someone can help. Thank you, Michele -- Dave Peterson -- Dave Peterson No I didn't. Thanks for noticing. |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com