Spreadsheet: 806915d1669666756-solved-not-reading-sumif-formula-sales-report-all-brands-2023-sample-
Sheet: TN

Location:
TENNESSEE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cases
 |  | Amargo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuenteseca | Fuenteseca | Fuenteseca | Fuenteseca | Fuenteseca | Fuenteseca | Fuenteseca | Fuenteseca
 | 3/4/5 | Angostura | ArteNOM | ArteNOM | ArteNOM | ArteNOM | ArteNOM | ArteNOM | ArteNOM | ArteNOM | Cimarron | Cimarron | Cimarron | Cimarron | Cimarron | Cimarron | Cimarron | Cimarron | [NAME] | De Napoleon | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Fernet | [NAME] | Reserva | Reserva | Reserva | Reserva | Reserva | Reserva | Reserva | Granada | Lapis | Lapis | Lapis | Lapis | [NAME] | [NAME] | Panama | Panama | Panama | Panama | Panama | PuraSangre | PuraSangre | PuraSangre | PuraSangre | PuraSangre | PuraSangre | PuraSangre | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | Royal Gate | White Xmas
 | Tres, Cuatro | Vallet | Anejo | Anejo | Blanco | Blanco | Historico | Historico | Reposado | Reposado | Blanco | Blanco | Blanco | Blanco | Reposado | Reposado | Reposado | Reposado | Bourbon | Liqueur | Anejo | Anejo | Arroqueño | Arroqueño | Largo | Largo | Pechuga | Reposado | Reposado | Rustico | Rustico | Tepeztate | Tepeztate | Tobala | Tobala | Tripon | Tripon | Vallet | Blanco | Anejo 7 yrs | Anejo 8 yrs | Anejo 11 yrs | Anejo 12 yrs | Anejo 15 yrs | Anejo 18 yrs | Anejo 21 yrs | Vallet | Anejo | Blanco | [NAME] | Repo | Blanco | Reposado | Pacific 3yr | Pacific 5yr | Pacific 9yr | Pacific 15yr | Pacific 23yr | Anejo | Anejo | Blanco | Blanco | Extra Anejo | Reposado | Reposado | Vodka | Vodka | Vodka | Vodka | Vodka | Vodka | Vodka | Gin | Gin | Gin | Gin | Gin | Gin | R & B | Sold
 | y Cinco | 6/750 ml | 6/750 ml | 12/375ml | 6/750 ml | 12/375ml | 6/750 ml | 12/375ml | 6/750 ml | 12/375ml | 12/750 ml | 12/1 Lt. | 12/375 ml | 24/375 ml | 12/750 ml | 12/1 Lt. | 12/375 ml | 24/375 ml | 6/750 ml | 12/750 ml | 6/750 ml | 12/375 ml | 6/750 ml | 12/375 ml | 6/750 ml | 12/375 ml | 6/750 ml | 6/750 ml | 12/375 ml | 6/750 ml | 12/375 ml | 6/750 ml | 12/375 ml | 6/750 ml | 12/375 ml | 6/750 ml | 12/375 ml | 6/750 ml | 4/750 ml | 4/750 ml | 4/750 ml | 4/750 ml | 4/750 ml | 4/750 ml | 4/750 ml | 4/750 ml | 6/750 ml | 6/750 ml | 6/750 ml | 6/750 ml | 6/750 ml | 6/750 ml | 6/750 ml | 12/1L | 6/750ml | 6/750ml | 6/750ml | 6/750ml | 6/750 ml | 12/1 liter | Fuerte | Fuerte | 6/750 ml | 6/750 ml | 12/1 liter | 6/1.75L | 12/1L | 12/1L BAR | 12/750ml | 24/375ml | 48/200ml | [NAME] | 6/1.75L | 12/1L | 12/1L BAR | 12/750ml | 24/375ml | 48/200ml | 12/750 ml
Month: | 4/750ml |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6/750ml | 12/1 liter
January – TN
February – TN
March – TN
Total lst qtr
April – TN
May – TN
June – TN
Total 2nd qtr
July – TN
August – TN
September – TN
Total 3rd qtr
October – TN
November – TN
December – TN
Total 4th qtr
TOTAL 2022