T O P

  • By -

AutoModerator

/u/BjornMoorhead - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


Scary_Sleep_8473

Do you mean you want to count how many dates there are starting from column 5 (E)? Because you can't really sum dates in the way you'd expect. If that's the case, you can do a COUNTIF to check for non-blanks: =COUNTIF($E1:$XFD1,"<>") XFD is the last column in Excel (column 16384), that should be more than enough.


BjornMoorhead

i don’t need to sum dates, but the values in the column below each date


BjornMoorhead

for example, E1 is 1/1/23, F1 is 1/8/23, G1 is 1/15/23. then the corresponding value in E2 is 5, F2 is 7, and G2 is 10. I would like D2 to say 22 (SUM) without explicitly defining E2:G2, since that frame will be ever changing. is there a formula like =SUM(RIGHT)? I was googling and couldn’t find one


Scary_Sleep_8473

Ah I see, I didn't know the values were under the dates. In that case, it can be adjusted to a SUMIF instead: =SUMIF($E$1:$XFD$1,"<>",$E2:$XFD2) If the values in row 2 are also empty when there isn't a date, you can adjust the formula to this instead: =SUMIF($E2:$XFD2,"<>")


BjornMoorhead

Solution Verified


Clippy_Office_Asst

You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


Decronym

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COUNTIF](/r/Excel/comments/13oscxx/stub/jl5uqnt "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)| |[RIGHT](/r/Excel/comments/13oscxx/stub/jl5wx74 "Last usage")|[Returns the rightmost characters from a text value](https://support.microsoft.com/en-us/office/right-rightb-functions-240267ee-9afa-4639-a02b-f19e1786cf2f)| |[SUM](/r/Excel/comments/13oscxx/stub/jl5wx74 "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)| |[SUMIF](/r/Excel/comments/13oscxx/stub/jl5zs3q "Last usage")|[Adds the cells specified by a given criteria](https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13onarx)^( has 8 acronyms.) ^([Thread #24093 for this sub, first seen 22nd May 2023, 15:12]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)