# Help with sales figures between a date or cell range

#### ianmn

##### New Member
Can one suggest a formula for the following;
Help with sales figures between a date or cell range

I have a sales spreadsheet with
Col A = Date. Col B = Invoice number. Col C = Name. Col D = Total Sale.
Col E = Vat Content. Col F = Net Sale.
I would like to have 2 cells where I enter either a Date or Cell Ref which would then lookup & add the the values in that range.

IE: Total Sales between 01/01/05 - 31/01/05 or D11 to D50 (these cell ranges would be changed by the user)

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
=SUMIF(\$A\$2:\$A\$400,">="&Date1,\$D\$2:\$D\$400)-SUMIF(\$A\$2:\$A\$400,">"&Date2,\$D\$2:\$D\$400)

where Date1 and Date2 are cells which house date criteria like 01/01/05 and 31/01/05 with Date1 <= Date2.

If the user specifies the D-range to sum by giving cell addresses...

=SUM(D11:D50)

Replies
1
Views
624
Replies
13
Views
388
Replies
23
Views
541
Replies
3
Views
160
Replies
5
Views
604

1,203,350
Messages
6,054,905
Members
444,760
Latest member
TeckTeck

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back