Hi All,
I am trying to produce a formula that sums based on two criteria but to scan over multiple tabs
I need the formula to accumulate numbers if they are in "Week 41" and under "Day"
So far I have come up with this but not sure if it is close or not:
=SUMIFS('>:<',$11:$11,"Week 41",$16:$16,"Day") the > and < are two empty tabs that all the tabs i need the formula to scan are between.
If anyone could help or has any questions to help answer it would be much appreciated,
Thanks.
Hi. Before we get going on this one...
Is your forum profile showing the Excel PRODUCT that you need this request to work with? I have no idea what "12" is....
The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.
The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.
ALSO>>>>
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
Thanks!
Glenn.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn,
Thank you for your promp reply, apologies for that I have now updated it to my version of Excel, MS365
Version 2202
Ta. Can we have a sample file, as requested, too?
Hopefully this file has attached(first time using this forum)
Basically, I am trying to make it so that if i change the week to 41 in the job tabs and put a value in the day column cell, the master resource tab will recognise that and accumulate them all
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks