10-31-2012, 11:29 AM
Attached is how I usually tackle such a problem. I used nested if functions returning a binary array with I then take the sun of, just remember to use ctrl+shift+enter when entering formulay (google array formula). Sounds more comlicated then it actually is but I find this to be a rather simple solution that is very flexible.
Regards Elabrto
Regards Elabrto
.