How do I do the following:
IF H7,J7,L7=6 is true, then add together G7,I7,K7. I want to add all
figures together that have a 6 in the adjacent column, and ignore others or
add zero.
How do I get this formula to drag across to the next column so that the '6'
changes to '7' but all else remains the same?
Also will the formula work if I have 7 columns of numbers and 7 columns of
figures?
I'm new to these conditional formulas so a specific formula would be
appreciated.
Thanks, Lil

--
Lil