sum units older then a date.

**bone7890** · 09-09-2015, 04:54 PM

Hey guys

I have a long list of product sales that i need to summarize based off date. what i am looking to do is pull all sales of a product that were made before a set date.

I am sure i am close but i just can't figure it out.

any advice would be much appreciated.

**Tony Valko** · 09-09-2015, 04:58 PM

Something like this...

Use cells to hold the criteria:

A1 = some product
B1 = some date

=SUMIFS(sum_range,product_range,A1,date_range,"<"&B1)

**bone7890** · 09-09-2015, 05:29 PM

THANKS!!!

I was missing the "&" i knew i was close.

thanks again for you help

**Tony Valko** · 09-09-2015, 05:35 PM

You're welcome. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

sum units older then a date.

LinkBack

Thread Tools

Rate This Thread

Display

sum units older then a date.

Re: sum units older then a date.

Re: sum units older then a date.

Re: sum units older then a date.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] What is the Formula for: IF Submit Date is older than Start Date, Display X

Remove Row if Date is Older Than - Help!

[SOLVED] Date older than 3 years? (yes/no)

[SOLVED] Calculate the Bonus units according to the quantity of the units bought (Help)

Delete lines with older date

How to pull out an older date...

I want any date 90 days or older from current date change color

Bookmarks

Bookmarks

Posting Permissions