Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 05:23:05 +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