Mar 11 2021 08:07 PM
Hi,
Hope someone can help me with this. I have been going nuts for two days trying to use COUNT(), COUNTA(), COUNTIF(), COUNTIFS() and SUBTOTAL() in various ways to do what I thought was a simple calculation.
I have a Spare Parts table for my boat with multiple columns including "Desired Qty", "On-Hand Qty" and "Qty to Order".
Above the table I have a Summary area where I want to display "Number of Entries", "Number of Entries with Parts On-Hand" and "Number of Entries Requiring Reorder".
I cannot get the "Number of Entries with Parts On-Hand" and the "Number of Entries Requiring Reorder" to calculate correctly when the table is unfiltered and filtered. One of the issues occurs when there is a blank in a "Qty On-Hand" cell rather than a 0.
Would really appreciate if someone could help with this. File is attached.
Thanks!
George
Mar 11 2021 11:23 PM
I think what you want is a conditional subtotal. See if the attached workbook is what you are trying to do.
Mar 12 2021 05:12 AM
SolutionMar 12 2021 11:08 AM
Mar 12 2021 05:12 AM
Solution