Note: I am a newbie.
I have a Card which shows the total number of containers shipped in the year, however I want it to only show the number of containers which have actually packed. My table also shows upcoming containers which need to pack and If the containers are not packed yet we do not put a date in the "DATE PACKED" Column. I need a way to read if Column A(Date Packed) is blank then the Card will not count the cell in Column B(No. Of Containers).
Date Packed | No. Of Containers |
---|---|
02/04/2024 | 10 |
05/04/2024 | 12 |
12/04/2024 | 10 |
24 |
I want Card to = 32 and not 56
The quick fix option I is to add a new column and separate the packed with the not packed but I am trying to minimize the number of columns on my worksheet as the whole one is already complex and would like to avoid extra edits.
Here is the formula that you can use:
=SUMIFS(your_no_of_containers_cell_range,your_date_packed_cell_range,"<>")