I have a cell that has the following formula:

=SUMIF(F3:J18,A24,G3:K18)

Basically what this does is add a series of numbers if a certain company is
charging me money for a specific issue. Each Issue is one row and may have up
to 3 companies charging me money.

Now there is another column that asks if this is a change order or not. The
options are "yes" or "no".

As it stands now the above formula adds numbers regardless of whether or not
I select yes or no. I only want it to add if column O reads yes.

Would that be AND formula?

Thanks,
Neil M