As happens far too frequently these days, my mind will not stretch to even a clue about how to set up a formula.
Here's the problem. I monitor our electricity consumption. I can download usage since the last billing date. I do so and load it into a spreadsheet (attached below). The days in the billing cycle are defined when I set up the spreadsheet. I've created a named range that contains the actual Kwh consumed each day. I created a formula that calculates as =SUM(July_Usage). This works fine. I'd like to be able to have the average daily consumption calculated without my entering the cell that contains the number of days. IOW, I'd like to be able to determine the last row with data and use the A column value to use as divisor to the total usage.
Can this be done? If so, how?
Need Help with a Formula
-
- UraniumLounger
- Posts: 9284
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Need Help with a Formula
You do not have the required permissions to view the files attached to this post.
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Need Help with a Formula
You can use
=AVERAGE(Usage_July)
The AVERAGE function only looks at filled cells. It ignores blank cells that have not yet been filled in.
=AVERAGE(Usage_July)
The AVERAGE function only looks at filled cells. It ignores blank cells that have not yet been filled in.
Best wishes,
Hans
Hans
-
- UraniumLounger
- Posts: 9284
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Need Help with a Formula
Mental blocks come far too often when you near 80.
Thank you, Mr. V.
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |