Blank out cell above if last cell has data

[Nvablejrg]

Good day all,

I am trying to blank out a cell above the last cell with data. I only want the last cell in Column J and K to show the total instead of all the cells with the same information.

I have a running total and the amount is the same from the top of the column. I already have a formula in the column and I want to only see the last cell that has data.

Can this be done with a formula in the cell already or do I have to use conditional formatting?

I have been searching and cannot find what I am looking for.

I am including a snapshot of the columns and one of the columns with the formulas in them.
Please see the columns "J" and "K". This is my running total of "Out" and "In" Items. I know why it has the same number in all the cells is because the formula is in all the cells.
This running total is totaling all the Column E (OUT or IN) with Column G (Amount). They are calculating the total "OUT" only and total "IN" only.

This is the formula in Column J and K
=IF(E3="","",SUMIF($E$3:$E$44,"OUT",$G$3:$G$44))
=IF(E3="","",SUMIF($E$3:$E$44,"IN",$G$3:$G$44))

Thank you all in advance.

Nvablejrg.

 

[maabadi]

Please test these two:

=IF(E3="","",IF(AND(COUNTIF(E3:$E$3,"out")=COUNTIF($E$3:$E$44,"out"),E3="OUT"),SUMIF($E$3:$E$44,"OUT",$G$3:$G$44),""))

=IF(E3="","",IF(AND(COUNTIF(E3:$E$3,"IN")=COUNTIF($E$3:$E$44,"IN"),E3="IN"),SUMIF($E$3:$E$44,"IN",$G$3:$G$44),""))

 

[maabadi]

Also Test this:

=IF(E3="","",IF(COUNTIF($E$3:E3,"out")+COUNTIF($E$3:E3,"IN")=COUNTA($E$3:$E$44),SUMIF($E$3:$E$44,"OUT",$G$3:$G$44),""))

IF(E3="","",IF(COUNTIF($E$3:E3,"out")+COUNTIF($E$3:E3,"IN")=COUNTA($E$3:$E$44),SUMIF($E$3:$E$44,"IN",$G$3:$G$44),""))

 

[Nvablejrg]

Also Test this:

=IF(E3="","",IF(COUNTIF($E$3:E3,"out")+COUNTIF($E$3:E3,"IN")=COUNTA($E$3:$E$44),SUMIF($E$3:$E$44,"OUT",$G$3:$G$44),""))

IF(E3="","",IF(COUNTIF($E$3:E3,"out")+COUNTIF($E$3:E3,"IN")=COUNTA($E$3:$E$44),SUMIF($E$3:$E$44,"IN",$G$3:$G$44),""))

maadabi,

Thank you for your reply.

I tried all of the formulas you provided and but they do not calculate. They do delete all numbers above the last used cell, but it is a ZERO.

Nvablejrg

 

[maabadi]

They worked all. Please upload your file with XL2BB (at the above of post reply section) to see what is error?
Also take screenshot at result of formula.

 

[Nvablejrg]

They worked all. Please upload your file with XL2BB (at the above of post reply section) to see what is error?
Also take screenshot at result of formula.

I went over the formula and my spreadsheet.

I had tweaked my original by moving columns and that is why I was getting a ZERO. After reviewing the formula I moved the reference to the correct column and it calculated.

I also like the way the calculation reflects at the respective last IN or OUT Row.

Your solution is PERFECT. Thank you very much. This cleans up my spreadsheet and allows for a quick acquisition of numbers of "In" and "Out".

 

[maabadi]

You're welcome & Good luck.