00:00I recently posted a video on counting number of people who have not paid membership using
00:04a simple count if function here.
00:06However, someone in the comment section had inquired if I can modify the formula to actually
00:12gauge based on a dollar value rather than paid or not paid status.
00:16And this is how you do it.
00:17First I'm going to introduce a new column called C here which is going to be called
00:21paid sum.
00:22Essentially what this does is that it looks at the status of the membership paid.
00:25If it's paid, I'm going to reflect here as $100.
00:28If it's not paid, I'm going to basically display a zero like this guy here.
00:33And after that, we can basically use count if like this.
00:38And the first argument of count if would be the paid sum column itself.
00:42And the second argument is $0.00 which actually counts the number of people who have not paid
00:47membership.
00:48And if you hit enter, you get the same number as looking at the status itself.
Comments