| Home |
| Search |
| Today's Posts |
|
#13
|
|||
|
|||
Most definitely...
In article , Aladin Akyurek wrote: Why not create an additional column, say E, that sums monthly values like in: E2, copied down: =SUM(B2:D2) which allows you to avoid expensive conditional calculations? nc wrote: Hi Domenic I tried using the following function, =SUMPRODUCT((A2:A6="Dividend")*(A2:A6="Interest")* (B2:D6)) with the table below and I get a value of zero. I was expecting 1200. Jan Feb March Dividend 100 100 100 Interest 100 100 100 Expenses -100 -100 -100 Dividend 100 100 100 Interest 100 100 100 Thanks. "Domenic" wrote: Sure... =SUMPRODUCT((RangeA="Criterion")*(RangeB="Criter ion")*(RangeC="Criterion" )*(RangeToSum)) Remove the quotes if your criterion is a numerical value. Hope this helps! In article , "nc" wrote: Thanks Domenic. Can this function be adapted to use more than one criteria. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| SumIF function | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| SUMIF function | Excel Worksheet Functions | |||
| help with "criterea" in the sumif function | Excel Worksheet Functions | |||
Threaded Mode
