Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 -- SUMIFS v SUMPRODUCT
I have had some very useful help from Jacob on an older version of Excel
where he sorted my problem out with SUMPRODUCT (see Problem with Syntax? posted below): =SUMPRODUCT(--(TEXT(B2:B20000,"mmyyyy")="012008"),--(C2:C20000="Motor"),(D2:D20000+E2:E20000)) The above formula works great, but I have two questions for Excel 2007 users: 1. If I convert B2:B20000 to B:B, why do I get a #VALUE error 2. Will SUMIFS do the above and if so, how? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumifs formula in Excel 2007 | Excel Discussion (Misc queries) | |||
sumifs formula in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - SUMIFS formula use between tabs | Excel Discussion (Misc queries) | |||
Excel 2007 SUMIFS | Excel Worksheet Functions | |||
[Excel 2007 Beta2] Function SUMIFS | Excel Worksheet Functions |