| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Domenic Wrote: Aladin has just pointed out that that happens because you have values like "" in the ranges to sum (his post to follow -- thanks Aladin, I hadn't thought about that :)). Acordingly, try the following formula... =SUM(IF(Sheet1!A1:A100=Sheet2!B11,IF(Sheet1!C1:F10 0<"",Sheet1!C1:F100))) ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! you're my new best friend -- thanks so much, it worked perfectly! -- mminsf ------------------------------------------------------------------------ mminsf's Profile: http://www.excelforum.com/member.php...o&userid=24767 View this thread: http://www.excelforum.com/showthread...hreadid=383325 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF using two columns in both Range and Criteria | Excel Discussion (Misc queries) | |||
| SUMIF using two columns in both Range and Criteria | Excel Worksheet Functions | |||
| SUMIF over multiple columns | Excel Worksheet Functions | |||
| Sumif over multiple columns | Excel Worksheet Functions | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Hybrid Mode
