#### steveh8204

##### Board Regular

- Joined
- Aug 20, 2018

- Messages
- 119

The problem I've got is some common values that I use to draw the info (Column F - highlighted) have values in multiple rows due to there begin an entry for each due date (Column L) so the Variance (Column Q -highlighted in Red) works them all out seperately which is incorrect.

Is there a way to show the variance in row Q to be the difference between the PO Total in Column I (the sum of cells I31-I33) and the PO total (repeated in cells P31-P33)?

Ideally when the PO information is similar as in this example Cells P31, P32 and Q31, Q32 would be blank, P33 would be 908.700 and Q33 would be 31,500.

Some of the units are different but the code I have that currently works out the variance converts these.

I know its an ask but I've spent hours trying stuff without any real progress. Thanks in advance for any help.