Using Functions to replace my VBA code

Hello all,

I need to run a spreadsheet that I have on my Android devices, but not one spreadsheet app I can find has any macro ability (and still be a decent app otherwise). I used to use PTab on WinMo. The paradigm has shifted away from enterprise apps on mobile devices, unfortunately, but I digress.

I have a VBA function that runs loops column data. It's pretty simple. It just checks to see if there is data in a cell, and then checks the "type" of data from the cell next to it. It them adds the data cell to a running total based on whether it should blindly add it to the total, or only the highest of that type (from the rest of the column) to that total. I need to know if this is possible, and how to do it, using functions. Or maybe there is a better concept I have not thought of. If anyone is familiar with D&D 3.5, then they'll know what I'm trying to do here.

I have this setup to recalculate the sheet after every cell edit, as Excel usually does. The sheet is "Effects".

Here is the code in Module 1:

Please Login or Register  to view this content.

Thanks in advance.

So I noticed the sticky for useful functions a little bit ago and started playing with sumproduct(). It looks like that can solve my problem. Will keep at it and let you all know if it does, so that this can be solved. Hopefully, I won't run into any snags.

OK. So it looks like I ran into one snag. I want to use the function to get the MAX() of multiple conditions added together. I can get the MAX() of multiple conditions without a problem. So I could, in theory, just add multiple uses of SUMPRODUCT() together, but is there anyway to get it to add up all the maxes in one go?