lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Have a data pull for financials, trying to make a repeatable store summary. $ values are on "Data" tab. Trying to collect by 3 categories - month, store name.
=SUMIFS(Data!$J$2:$P$1214,Data!$B$2:$B$1214,Sheet1!$B3,Data!$J$1:$P$1,Sheet1!C$2,Data!$F$2:$F$1214,Sheet1!B2)
Values are in cells J2:P1214, categories are F1:P1, months are B, store is F. So from the table, is should sumifs numbers that have the same store in F, the same month in B, and the same category in row 1. Keep getting the #value error though.
=SUMIFS(Data!$J$2:$P$1214,Data!$B$2:$B$1214,Sheet1!$B3,Data!$J$1:$P$1,Sheet1!C$2,Data!$F$2:$F$1214,Sheet1!B2)
Values are in cells J2:P1214, categories are F1:P1, months are B, store is F. So from the table, is should sumifs numbers that have the same store in F, the same month in B, and the same category in row 1. Keep getting the #value error though.