SUMIF formula help with a table please

[MnMCarta]

Hello this is my first post so I hope I do it right

I'm trying to get a formula that will calculate the sum of entries before todays date and then the column to the right of it to calculate the sum of entries after todays date. There is an option for them to select "OUT" in those boxes and I'm not worried about them counting as anything as I have them counted in another column. The two columns are highlighted in yellow. Can anyone help me please?

[Pauleyb]

When I try to open your workbook I get a dialog box stating it has unreadable content. It then says that if I want to recover the data and trust the source then I should click 'Yes'. Well, no offense, but I can't say I trust the source, so it remains unopened. Not sure what happened, but you may want to try again.
Without the benefit of your spreadsheet, you should investigate the function SUMIF and utilizing TODAY() as your check.

[FDibbins]

I did not have the same problem opening your file as Alan did.

In NO4, copied down, try this…
=COUNT(OFFSET($I4,0,1,1,MATCH(TEXT(TODAY(),"d-mmm"),$I$3:$NK$3,0)-1))

Then for NP4, copied down...
=COUNT(I4:NK4)-NO4

[MnMCarta]

I'm sooo sorry everyone I don't know what happened. I pasted the info I needed in a new sheet alone so hopefully it was some macro I may have made back in the day. Hopefully this will work.

I can't figure out how to delete the file so please use the file named "Help Please file"

oooo I see where someone else gave me a try. Thank you soooo much! :D Goin to try it now.

[FDibbins]

let me know how you make out?

(on a side note, I hate the structured format excel uses for ranges, so I often just type them in, instead - that way they make more sense to me)

[MnMCarta]

OMG IT WORKED!!!!!!!! (not that I doubted you at all. I get really excited when things work for me) lol I can't thank you enough!!!! It was really hard to reach out for the help but I just couldn't do this one on my own so thank you soooooo much (BIG HUGS!!!) :D

[FDibbins]

You just put a huge smile on my face, next time dont wait so long

happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

Would you know how to use that in future, or how to edit it for other applications? (just curious)

[MnMCarta]

Okey dokey. I will do that. Was tryin to find if there is somewhere where I can mark yer comment as awesome lol

[FDibbins]

Thaks for the feedback, always appreciated

[MnMCarta]

Oh I didnt see the 1-3 you wrote. I dont get #1. Found #2 and #3. Not sure about your question to editing. :/

[FDibbins]

Point 1 is only if you are uploading VBA code (you're not, so it doesnt apply here)

My question regarding editing, was aimed at the formula I gave you...
=COUNT(OFFSET($I4,0,1,1,MATCH(TEXT(TODAY(),"d-mmm"),$I$3:$NK$3,0)-1))
What I meant was, if needed, would you be able to edit that to use it in another (different) situation? (in other words, do you need it explained? If not, thats cool too)

[MnMCarta]

Oooooooooo I see. Well I dont fully get ut but let me try to figure it out amd if I get stuck I will certainly reach back out to ya. Really appreciate that One question though... how does someone upload a profile pic? Lol

[FDibbins]

This gets done inthe Settings option, under "edit avatar"