#### dcartwright

##### New Member

- Joined
- Feb 22, 2006

- Messages
- 31

I would appreciate some help with a problem that I have.

Below is a simplified version of a spreadsheet I have.

What I am trying to do is this. I want a formula writing that looks up a "Reference Number" in sheet 2 of my spreadsheet. I then want it to add up from Sheet 1 any any values from column D (Consumption Kwh) where column A (Reference Number) is the value from Sheet 1 that I have specified AND where Shhet 1 column B (Year) = 2005-06 AND where Sheet 1 column C (Period)is between 3 and 8

Thanks in advance

Dave

Book1 | ||||||
---|---|---|---|---|---|---|

A | B | C | D | |||

1 | ReferenceNumber | Year | Period | ConsumptionKwh | ||

2 | 18736693 | 2005-06 | 3 | 3,893.00 | ||

3 | 18736693 | 2005-06 | 2 | 1,722.00 | ||

4 | 49734345 | 2004-05 | 4 | 166,442.00 | ||

5 | 18736693 | 2005-06 | 7 | 27,458.00 | ||

6 | 92736697 | 2005-06 | 6 | 23,715.00 | ||

7 | 11113660 | 2005-06 | 10 | 49,717.00 | ||

8 | 18736693 | 2005-06 | 5 | 14,116.00 | ||

9 | 18736693 | 2004-05 | 7 | 8,723.00 | ||

Sheet1 |