Hello,
I am trying to write a COUNTIFS formula to include a criteria that will subtract a value in column P from the row below in column I and if the result is less than 0 then it should be counted, but I can't seem to write this correct so that excel will accept this. Any help is appreciated. Thanks!
IF(B4="","",COUNTIFS($B$4:B4,B4,$O$4:O4,"=0",$P3-$I4, "< 0")*(B4=B4))
<tbody>
</tbody><colgroup><col></colgroup>
I am trying to write a COUNTIFS formula to include a criteria that will subtract a value in column P from the row below in column I and if the result is less than 0 then it should be counted, but I can't seem to write this correct so that excel will accept this. Any help is appreciated. Thanks!
IF(B4="","",COUNTIFS($B$4:B4,B4,$O$4:O4,"=0",$P3-$I4, "< 0")*(B4=B4))
|
<tbody>
</tbody><colgroup><col></colgroup>