|Hi All, I thought this would be simple, but now I am stumped!|
i am trying to add up 14 cells with varying info in them:
all cells are side by side i.e (H5:U5)
I basically need the formula to look at each cell and if it has ANY of the following:
7,7A,7R,3,3A,3R,11,11A,11R to give it a value of 8 and then sum it up.
For example, if i had 6 different cells with 7,3A,11,7R3,11 showing in them, the formula should return to me: 48
If this isn't hard enough I have another one that needs the same type of formula except it need to return values of 6 or 8 depending on the criteria.
Same 14 cells, formula to look at each cell and if it has ANY of the following:
7,7A,3,3A,11,11A, to give it a value of 8 and then sum it up AND look for 730,730A,330,330A and return the value of 6 and sum it up.
Any help would be appreciated, I am not a computer expert, but know my way around enough, this seems like it would be simple but alas, I cannot crack this one.
Thank you all!