Please take a few minutes and read the ForumRules about cross posts.
Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.
It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post
As a footnote to the other post, with 80 sheets it might be easier to perform a Sumif on every sheet
E1 =SUMIF(A:A,A1,C:C)
and then on the summary page or wherever
=SUM(Sheet1:Sheet2!E1)
Bookmarks