Problem with the Table

[firstWeMeet]

Anyone has a solution here?

The table above has IN and OUT but not maintaining IN and OUT cause at the next word IN or OUT showing with the number. I want to maintain the table but IN and OUT will not show with the number until to the end of record.

 

[mole999]

any formulas in the cells?
what is the end of record
what values are stored under in out

 

[firstWeMeet]

at the table IN and OUT has no formula, just a data which is the Qty, then at the end, all IN and OUT will compute all IN and OUT separated to compute all IN here is my formula =SUMIF(Table_INandOUT,"IN",P7:AG7) but formula cant sum all IN since the other IN has a number 1,2,3 and so forth,

 

[mole999]

willl not

=sum(A2,C2,E2,G2,I2,K2) 'point at each IN

work