I have large excel file with list of new connections of my company with Dates in Column T, Place Names in Column AA & Status of connection (New Customer / Old Customer) in Column D. I have used COUNTIFS so far to get count of New Customers, Old Customers individually based on one date & one place.
=COUNTIFS($Data.T1:T95536, D1, $Data.AA1:AA95536, B6, $Data.D1:D95536, “New”)
Where, D1= Date I enter manually B6 to B14 are Place Names (fixed format by the Company) filled with same formula
Formula for “Old” is written in another column.
Now, I want to have count of both New & Old customers in a column (Column R in this case) in another Sheet like below.
=SUM(COUNTIFS($Data.T1:T95536, R71, $Data.AA1:AA95536, C60, $Data.D1:D95536, {“New”,“Old”}))
R71, S71, T71… = Dates in increasing order manually entered as reference. C60, C61… C68 = Name of places (Fixed format)
This formula is working in Microsoft Office but not working in Libre Office.
Is there any alternative formula to fulfill my purpose. Please guide.