Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Two Conditions | Excel Worksheet Functions | |||
Sumif with conditions | Excel Worksheet Functions | |||
SUMIF with two conditions | Excel Worksheet Functions | |||
Sumif with n conditions | Excel Worksheet Functions | |||
sumif with 2 conditions ?? can this be done?? | Excel Worksheet Functions |