Forum Discussion
how to get a cell to return a value based on another cell
Im very novice to formulas, but been learning. I'm searching for a functions that will add an amount per cell for a range of cells, if criteria is met in a separate range, example. If the data in C34...
=300*COUNTIF(C34:C39,">1")+SUMIF(C34:C39,">1",G34:G39)
Alternatively:
=SUMPRODUCT((C34:C39>1)*(G34:G39+300))
HansVogelaar OMG thank you!!!!