Re: Time if/then caclculate average formula?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

How would you do it on paper? If we have your paper formula, we can tell you
how to do it in Excel.

Tyro

"Tom T" <tominkirkland@xxxxxxxxx> wrote in message
news:62ecn5F237o0sU1@xxxxxxxxxxxxxxxxxxxxx
Hello,

I have been keeping track of my blood pressure with an Excel spread***.
I list "date" on column A, "time" on column B, "Systolic" on column C,
"Dia" on column D, and "Pulse" on column E (Columns A, B, C, D, E).
Currently I have a formula to give an overall average of column C in one
box, Column D in another, and Column E in another.

I want to add an Average box for each column C, D, and E based on the
time of day (column B) to include only if they are readings between a
certain time (for example, time is after 5 PM but before midnight). Does
someone here know how to do this?

Any help with this would be much appreciated.

Thanks!

Tom

--
http://www.rvlover.net
http://weather.rvlover.net



.

Quantcast