Sumif

[dlundo]

I have attached the worksheet with details of what I'm looking for in cell A39:42. Thanks in advance for any help!

[TMS]

Forget about column I; it's a waste of time.

Use:

O3: =SUMIFS($K$3:$K$37,$F$3:$F$37,"<="&$N3,$G$3:$G$37,">="&$N3)

and copy down.


Regards, TMS

[dlundo]

TMS,
Thank you very much for the help!

[TMS]

You're welcome.

I'm bemused ... I've never had rep with no points before; mostly positive, the odd negative, but never a break even. I didn't know you could do that ... how did you do that?


If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[dlundo]

Not entirely sure what your asking, but if it refers to showing my appreciation for your help, I did click on the star at the bottom of your post. I don't remember it allowing me to add appreciation "points", however I would have awarded you the max. Thanks again and I may have another addition to the formula.

[TMS]

Yes, thank you for the thought ... which was positive. For some reason, there were no points and that seems to relate to how long you have been a member of the forum and/or how many posts you have made. It seemed strange as, in about 18 months, I'd never seen it happen before. I thought it might have been a gremlin in the system but it seems not so.

I'll look forward to your next question! I would advise a new thread though as that will get more people looking at it.


Regards, TMS

[dlundo]

TM,

Being that you solved the initial formula I figured you'd be able to write this one w/out issues. I'm looking to use (2) tabs, "monthly" & "weekly". On the "weekly" tab I only want to show the info in columns L thru O (A thru K will be deleted). I'm looking for that info to be populated from info on the "monthly" tab. Info from the "monthly" tab (columns F,G,H, & I) is the same info that you wrote the initial formula. I'm just trying to solely show the results on the "weekly" tab.

Hopefully this makes sense. I've attached a revised spreadsheet with (2) tabs.

Thanks!