I have created a spreadsheet where I can add multiple invoices for several states on one tab and they populate on each individual state tab and add up together. I have used this formula {=SUM(IF(Invoices!A1:$A$1009=$A$11,Invoices!D$1:D$1009,""))} but it is not populating the results on each page. The lookup values on each tab are unique by listing the month and state (example: January - WA or January - TX). This is what I list in the A column on the Invoices Tab. My thought is that the spreadsheet is trying to calculate too many cells, since there are 30+ state pages and several different products? Any advice on how to get this to work?
Bookmarks