How to skip cell value if row header contains certain text
Andrew McAtee
I have a workbook for tracking my inventory in real time.
I want to have my inventory crew count and add the data in line along with the receiving and departing shipments of 12oz bottles. For instance, when we Start the week with 343,520 bottles. This number is totaled out and placed in J5. The next day we check the count and enter in 343,520 and is placed in J6. The totals of the rows pallet and layer count are sumed for each row (or action) and placed in the L column.
To get the current total on hand, A2 sums L5:L47. However, I do not want the total to reflect as 687,040. Instead I want the equation to reference Column A and see that A6 says 'Inventory' or 'Inventory Count' and know to skil J6 when A2 (Total Bottles on hand) is summing L5:L47.
ernie
You can use the SUMIF function for this. You'll want something like:
=SUMIF(A5:A47, "<>Inventory*", L5:L47)
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
- 이전 게시물：R에서 regexp를 사용한 정확한 문자열 일치
- 다음 포스트：How to Fetch common column from multiple tables in Database?
관련 기사
Related 관련 기사
- 1
How to get excel row numbers to skip the header
- 2
Determining if Excel cell contains array formula or text value
- 3
In protractor, how do I check if a table cell contains particular text?
- 4
How to add a row and change cell value in DataGridView from a different thread?
- 5
How to get value of cell knowing neighboring cell from same row in sql db?
- 6
Jquery find/Contains and replace table cell value
- 7
dataTables custom filtering of <tr> if cell contains value
- 8
Deleting rows based on cell value in a certain column
- 9
How do I extract text under a specific header which starts with a certain set of words
- 10
How to change cell value down one column into another but change the row value?
- 11
How to skip a row with file exists condition in laravel
- 12
How to get a particular table cell text with row column values in Capybara without looping?
- 13
How do extend text in cell beyond the cell?
- 14
How to add colspan and text in cell?
- 15
Echo certain pieces of text only if a value is filled in
- 16
How do I skip a listview row when saving into the Database?
- 17
How do I test if a cell in OpenOffice Calc contains #N/A?
- 18
MySQL Join table row based on lowest cell value
- 19
How to paste values in a certain text position in VBA?
- 20
jqGrid 4.8.0 - How to get cell type or cell value using jsonmap
- 21
How To Repeat Cell Value X Times In Excel One Cell
- 22
Can I return a text value if a certain tag is found?
- 23
How to reduce the value of a column in a row with?
- 24
How to read value in cell from database
- 25
How to get value of a gridview cell in this scenario
- 26
How to get the indexpath.row when a UIImageView in a cell is tapped?
- 27
How to pull day of month from Column header including row data?
- 28
How to not read the header row while reading csv using Scanner?
- 29
"How to create two text widgets in a row widget"
몇 마디 만하겠습니다