Hi,
I assume that you have Go in column G and yes in column H, then you want to
sum column I

=SUMPRODUCT(--(G6:G20="GO"),--(H6:H20="YES"),I6:I20)

change range to fit your needs, all ranges has to be the same among the
formula

"MHSGal" wrote:

Hi community,
I'm stumped on conditional formulas. I'm trying to create a formula that
will do the following:
*Look at a particular column and if a cell says "Go" and if another cell in
a different column (on the same worksheet) says "Yes", then add up the dollar
values associated with the cells that meet both of those conditions. I've
tried sumif, and dsum and can not quite get it to work. Can someone please
lend some excel expertise. Is this even possible?