Support Board
Date/Time: Sun, 24 Nov 2024 20:52:06 +0000
Post From: Study sub graph difference MA
| [2013-11-28 22:08:35] |
| TastyRisk - Posts: 119 |
|
Hay, User... You know I'm learning myself here, that's why I'm helping you, actually! I think that even if the SUMIF formula can be modified by an COUNTIF external value; there still exists the problem which is that the COUNTIF range is not dynamic itself. However; the MATCH function should solve that. Here is a good example... http://www.mrexcel.com/forum/excel-questions/162666-can-excel-formula-count-until-certain-sum-reached.html Date Time Of Last Edit: 2013-11-28 22:11:46
|