shornbuckle’s Profile

Community member since July 2018



Hi, I am putting together a sumifs formula and it works for all criteria except this situation:

With my working formulas, my range is just a column value but now I need a formula with the same criteria but I need to range to be the sum of 2 columns.

This is my working formula with a single column



I am trying to create a formula to give me a specific "status" based on a couple of criteria's. 

My formula is this =IF(ISBLANK(RFx37), "Need RFx",IF(ISTEXT(RFxx37), "Need PO", IF(ISTEXT(POx37), "Open PO")))

I want to status cell to update based on other cells.

My columns are Status, RFx, & PO.