Formula For Sum By Date Involving Multiple Cells

Details are sketchy for sure, but sounds like you could use SUMIF for that..

'on a different worksheet', put
=SUMIF('Sheet1'!A:A,"<>",'Sheet1'!B:B)

Adjust the name Sheet1 to reflect the name of the sheet you would enter dates in column A
It will sum values in column B that have dates corresponding in column A.

You are amazing, thank you!!!

You're welcome.

Just to clarify, strictly speaking it's not looking for a 'Date' in column A.
Basically it's looking for A to be Not Empty

Okay, if I wanted to do only a date range of like...1/1/17-1/31/17, is it possible to do that as well?

Definitely, sumifS can do that..

=SUMIFS('Sheet1'!B:B,'Sheet1'!A:A,">=1/1/2017",'Sheet1'!A:A,"<=1/31/2017")

You can put those dates in a couple cells too, say D2 and E2 for example
=SUMIFS('Sheet1'!B:B,'Sheet1'!A:A,">="&D2,'Sheet1'!A:A,"<="&E2)

Thank you, and I apologize. Hope my title is much better.

Worked like a charm, much thanks!

I think I fixed it, thank you for the heads up. Will do better, I promise.