If Blank Formula

Shannon Lacerda

Can someone help 'I am trying to add up a Value Column (2021 Opportunity Log Range 1) with the criteria

if the (Estimator) column is NOT blank and the (RANK) column has a "A" in it.

My formula above I get the below

Dale Murphy

@Shannon Lacerda I think you need to use SUMIFS not SUMIF ...

Dale

Shannon Lacerda

@Dale Murphy unfortunately I tried that as well, I get #INVALID OPERATION when I use SUMIFS

Dale Murphy

@Shannon Lacerda Can I see the SUMIFS formula you tried? The structure is a bit different ...

Dale

Shannon Lacerda

@Dale Murphy

Shannon Lacerda

@Dale Murphy thanks I moved the formula around and it works thanks