dcartwright
New Member
- Joined
- Feb 22, 2006
- Messages
- 31
Good afternoon
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
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 |