| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumproduct or sumif?
is one preferable to the other, since i can use either and get the
same result? thanks Sumif can test for only one condition, but Sumproduct can test multiple conditions [ see http://www.xldynamic.com/source/xld.SUMPRODUCT.html ]. So if you're testing only one condition, use Sumif. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need SUMIF / SUMPRODUCT help I think | Excel Discussion (Misc queries) | |||
| SumIF or SumProduct | Excel Discussion (Misc queries) | |||
| sumproduct and sumif | Excel Worksheet Functions | |||
| Sumif or Sumproduct? | Excel Discussion (Misc queries) | |||
| Sumif or Sumproduct | Excel Worksheet Functions | |||
Threaded Mode
