Feb 22 2018 09:56 AM
I'm trying to create a formula that will add together a list of numbers in a column (B) based on the value of another column(A), however I also want to add a condition to divide the number by 2 before it calculates the total if "/" is present in column A.
Hope this makes sense, thanks in advance!!
Feb 22 2018 02:27 PM