You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello everyone, i was trying to get results between two dates. See the screenshots
i have one sheet with information and other sheet with percentages. I want to sum how much is my income between two dates using the specific percentage i provide for between the two dates.
[Re-Titled by Moderator]
MacBook Pro 13″, macOS 15.0
I do not know what values you are trying to sum but the general formula for summing values between two dates is:
=SUMIFS(values_to_sum, dates, ">="&first_date, dates, "<="&last_date)
where
Hello, thank you for your reply.
what i am trying to sum is the Total amount. For example
now it’s from 9/11/24 till 9/11/24 i got € 303. And the column with the title Mijn loon is the 25% of the total. What i am trying to do is when i change a date. And the percentage of that date is different. I want to get the right amount on the Mijn loon cell
that means € 303 * (percentage that corresponds between two dates) = in this case €75,75
but if i the date for example from 1/22/24 till 1/1/25 then the percentage will be 30%
i hope you got my point. Again thank you for your reply.
If the beginning and ending dates fit entirely within a single date range for the percentage (i.e., there will be only one percentage that matches that span of dates and the sum will be multiplied by one percentage), you can use SUMIFS or MINIFS to look up the percentage. But if your dates span two or more percentages, your best bet is to do more work in the table that has all the amounts. In that table, add a column to look up the percentage for each row. Add another column that multiplies the amount on that row by the percentage. Use that column in the SUMIFS formula.
Which is it? Will there be a single percentage or might there be more than one percentage with some of the amounts multiplied by one percentageand the rest multiplied by another?
Hello again,
thank you for your reply.
i am using this formula
D3×SUMIFS(Percentage;Percentage::A;"<="&$C3;Percentage::Tot;">="&$C4)
but this one is like you said it works only when i have one percentage for date in between two dates.
it’s better to do the second option. Because maybe someday i’ll have two different percentages for the same date range.
How can I sum income between two specific dates in Numbers?
