Help Solving SUMIF Formula Issue [SOLVED]

Requesting urgent help to solve an issue with a SUMIF formula in Excel. I was asked by my manager to put together a spreadsheet of data on Friday, to present on Monday, and spending my entire weekend trying to figure this out. This is the last piece I need to have this working, but I?ve search all over Google for people doing the same thing as me, with no luck. If someone can answer how to do this with SUMIF or a different formula, you?ll be a lifesaver. Thank you!

I?m trying to SUM the value each member on a team has to allocate per project. A Primary in phase1 is a value of 2 and a Primary in phase2 is a value of 4. We?re tracking each phase by month, and trying to Sum the overall value of all project in a specific quarter.


For example, John is a Primary for the America project, which falls in Q1-2024 (Jan-24, Feb-24, Mar-24). He has no other projects in Q1-2024 and phase 2 for the project is not until Q2-2024 (Apr-24, May-24, Jun-24). So he should have a value of 2 for Q1-2024.


My issue is the formula I?m using is counting each month more than once and adding a value each time (so it?s adding 2 each time the formula sees the month), which is showing John as a value of 6 instead of 2 for Q1-2024. I?d like to have the formula count each month only ONCE when summing the value for a quarter. Is there a way I can do this?

 Here is the formula or reference


=SUM(SUMIF(D2:D4,{"*Jan-24*","*Feb-24*","*Mar-24*"},E2:E4)+SUMIF(F2:F4,{"*Jan-24*","*Feb-24*","*Mar-24*"},G2:G4))


Is there a way I can use OR when referencing the criteria? For example:
=SUM(SUMIF(D2:D4,{"*Jan-24*" OR ?*Feb-24*" OR?*Mar-24*"},E2:E4)


I?m not very experienced when it comes to Excel and would appreciate any support in figuring this out. Thank you so much for your time and reading this post!

Images are pretty much useless. Please read the yellow banner (top) and attach an Excel file.

crossposted: https://www.mrexcel.com/board/thread...o-put.1240391/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.

Cell B17 formula , Drag down and across

Formula:

Please Login or Register  to view this content.

Hi EXCEL_HELP_NEEDED_P
Included, please see the attachment

Formula:

Please Login or Register  to view this content.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.