Conditional Formulas
If I didn't missunderstand you have your data in sheet 2 and you want to have
the sum in sheet 1 just you need to enter the sheet name as follow
=SUMPRODUCT(--(sheet2!G6:G20="GO"),--(sheet2!H6:H20="YES"),sheet2!I6:I20)
change the sheet name for yours
"MHSGal" wrote:
Thank you Eduardo!!
Quick question, your response makes perfect sense. Would my formula change
if I'm trying to return the sum in one sheet and retrieve the data from
columns g and h for another worksheet?
"Eduardo" wrote:
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?
|