Reply to thread

Message: [QUOTE="Dave Peterson, post: 13182495"] in xl2007, you can use =sumifs() (read excel's help for more info). In any version, you can use: If A1:A10 contains text (not dates): =sumproduct(--(b1:b10="sup1"),--(a1:a10="apr 09"),(c1:c10)) If column A contained real dates: =sumproduct(--(b1:b10="sup1"),--(text(a1:a10,"yyyymm")="200904"),(c1:c10)) 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 here: [URL]http://www.xldynamic.com/source/xld.SUMPRODUCT.html[/URL] And J.E. McGimpsey has some notes at: [URL]http://mcgimpsey.com/excel/formulae/doubleneg.html[/URL] ====== As long as you're using those names, put this in A1: =indirect("sheet"&row()+1&"!a1") and drag down. [/QUOTE]