Hi there,
The sumif function i am using to add earnings if the years are same. However, for some reason I am getting the wrong summation.
Any help would be highly appreciated
Hi there,
The sumif function i am using to add earnings if the years are same. However, for some reason I am getting the wrong summation.
Any help would be highly appreciated
The totals ARE correct. What makes you think that they are not?
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
looks ok to me
have you noticed the years are not in order
2024 =
row 5 to 9 AND also row 11
as ROW 10 is 2023
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Unless the OP wants a value that crosses a year end to be split. But... that wasn't asked for and I don't play guessing games.
just for clarity - i have highlighted the years so you can see where the year is out of the sequence, are you just assuming the year is sorted in order and hence why you think its miscalculating ?
I realized yes the years are not correct/ in order. Apologize for not noticing.
Then again thank you for your help Glenn and Etaf
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks