Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • 1
    What have you tried so far and where are you stuck? It seems like an IFS() function would do it for you...
    – gns100
    Commented Aug 19, 2021 at 0:00
  • Hi @Ryan Corby ,, getting SUM/AVERAGE and others across sheets are popular practice but works only by using single formula,,, if & when data illustration is in similar columns,,,so please edit your post & modify the need,, if your need is fixed that you get SUM from different data points then please be specific,,, also use TAG VBA to the post, cozz VBA macro can meet your requirements!! Commented Aug 19, 2021 at 5:13
  • Readers please do not VOTE negative to CLOSE this post since it's a challenging question to solve,,, is different,,, and this might be situation in day 2 day working,,, this community has many experts,,, so keep it alive and try to find solution,,, I'm also trying to fix it ☺ Commented Aug 19, 2021 at 5:21
  • If you can provide a sample about this problem, it will be more helpful.
    – Lee
    Commented Aug 19, 2021 at 8:14