Hello All,
I am trying to get excel to count and sum multiple criteria in a specific cell when cell has multiple criteria (ALT + ENTER) inside the same cell. I am able to make it count if I have each value in separate columns/cells, but it will not count if I have name 1, name 2, name 3, etc. all in the same cell. Thank you.
I am trying to get excel to count and sum multiple criteria in a specific cell when cell has multiple criteria (ALT + ENTER) inside the same cell. I am able to make it count if I have each value in separate columns/cells, but it will not count if I have name 1, name 2, name 3, etc. all in the same cell. Thank you.