Spreadsheet: 806914d1669666316-solved-not-reading-sumif-formula-sales-report-all-brands-2023-sample-
Sheet: PA

Location:
PENNSYLVANIA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 – PA
February – PA
March – PA
Total lst qtr
April – PA
May – PA
June – PA
Total 2nd qtr
July – PA
August – PA
September – PA
Total 3rd qtr
October – PA
November – PA
December – PA
Total 4th qtr
TOTAL 2022