Hello again, Excellent people!
I`m having some problems with counting individual entries in a huge table [120969 rows / 20 columns and counting].
I`m trying to extract individual entries from a specific month (month \ year varies) (and then year), where the entries are tied with another column.
[how many individual vehicles (A:A) does a company [C:C] has for specified month/year [B:B])
Unique formula doesn`t seem to work on my MS 365 ProPlus, so I've tried SUMPRODUCT and other examples from the web.
Formula:
Please Login or Register to view this content.
and
Formula:
Please Login or Register to view this content.
These formulas should work, but I`m doing something wrong apparently.
I have attached a scaled down version of the table. Any help would be greatly appreciated.
Thank you!
Bookmarks