Dll Not Found/Missing Error------Repair You Dll Errors : Troubleshooter of Error: Sum Product by Date Range

Monday, February 22, 2016

Troubleshooter of Error: Sum Product by Date Range

Sum Product by Date Range

I have a program that has a list of grades in seperate rows, with corresponding weights. I want to be able to sum the weights based on a time manner.

For example here is my spreadsheet that my information is from, this tab is called 'UNL'.

Reference Cancel
Weight
Transmission
Grade
Grade Code
Date

00010
44.124
1000
00F25
2 SRW
August-11-11

00011
47.120
1000
00F25
2 SRW
August-12-11

00012
47.208
1000
00F25
2 SRW
August-12-11

Weight is in Column G, Date is in Column R and Grade Code is in Column N....
there are hidden columns in there for calculation purposes.

So now I have my tally sheet for a week...
that looks like this, tab, 'totals'

08/11/2011

15/11/2011

Unloads
Shipments
Outstanding

2 SRW

3 SRW

4 SRW

Total

So based on the other sheets my total in cell B3, should equal, 138.452, because they are in the date range, located in b2 and d2

I want to be able to change the date, and look at the transactions per date.

Thanks for everyones help

Keys to the Problem Sum Product by Date Range

Download SmartPCFixer to Fix It (Free)

> Weight is in Column G, Date is in Column R and Grade Code is in Column N....
there are hidden columns in there for calculation purposes.

The logic would be this, with your codes in column A starting in A3, the starting date in B1, ending date in C1, enter this in B3 and copy down. Not sure where your headers in row 2 (unloads, etc) come into play....
=SUMPRODUCT((UNL!$G$2:$G$1000)*(UNL!$R$2:$R$1000>=$B$1)*(UNL!$R$2:$R$1000<=$C$1)*(UNL!$N$2:$N$1000=$A3))
If your headers are data values in your table, and are in column XXX, then
=SUMPRODUCT((UNL!$G$2:$G$1000)*(UNL!$R$2:$R$1000>=$B$1)*(UNL!$R$2:$R$1000<=$C$1)*(UNL!$N$2:$N$1000=$A2)*(UNL!$XXX$2:$XXX$1000>=B$2))

You could also do this without any formulas by using a pivottable.
Bernie

Machine Throttling

Go to the Start button.
In the Search box, type "regedit" (without quotes) and press Enter.
Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
On the right window pane, delete the subkey: "Machine Throttling".
Reboot your computer.

Recommended Method to Fix the Problem: Sum Product by Date Range:

How to Fix Sum Product by Date Range with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Run it, and it will scan your system. The errors will be shown in the scan result.