Issue in getting value populated in QoQ

Abdul Razack 20 Reputation points
2026-09-19T19:29:29.4066667+00:00

In excel file and refer ta FLUX,

The issue is in QoQ,

Say, if the current month is July (D6 in Flux tab),

and its corresponding Quarter is Q3, selected from the drop down

Jul is the first month of Q3, hence the flux in ColH in Flux tab should show the result of Q2 first month only

and if we select Aug which is the second month of Q3, the in Q2 Apr & May subtotal should populate

Q3-26 values are not getting populated, but Q1-26 and Q2-26 are getting populated.

Microsoft 365 and Office | Excel | Other | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ian-T 11,970 Reputation points Microsoft External Staff Moderator
    2026-09-20T01:09:09.22+00:00

    Hi @Abdul Razack

    Since Q1-26 and Q2-26 populate correctly but Q3-26 does not, the issue is likely specific to the Q3 lookup criteria or source range rather than Excel calculation itself.

    Please check the following:

    1. Confirm that the quarter label is identical everywhere, for example Q3-26, with no extra spaces or different dash characters.
    2. Verify that the formula in column H includes the Q3-26 columns or rows. The lookup or SUMIFS range may currently stop at Q2-26.
    3. Check whether D6 contains a real Excel date or only text such as Jul.
    4. Use Formulas > Evaluate Formula on the affected cell to see which condition or lookup fails.
    5. If the formula was copied across, compare its references with a working Q2-26 formula and check for incorrect absolute references.

    Could you share the formula from the affected column H cell, plus the month and quarter header ranges?

    Thank you for your time

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.