returning a value from a string in a single cell
I am in the US.
--
Alan
"Dave Peterson" wrote:
Do you use USA settings?
Do you use an English version of excel?
For most people in the USA, the list separator is a comma. For lots of other
folks (are you in Europe), they use a semicolon (;).
AG wrote:
I used the formula as listed by Bob.
The error message I get is: "The formula you typed contains an error."
It offers no help to correct the error.
--
Alan
"Dave Peterson" wrote:
What formula did you use? What error message did you receive?
AG wrote:
When I enter this formula into my spreadsheet, I get an error message. Here
is how the data is loaded into the spreadsheet:
date hours
1/1/05 36.5
12/15/05 15.2
8/8/05 24.0
I need to select the data in the "hours" column based on the month in the
"date" column.
--
Alan
"Bob Umlas" wrote:
If the dates are in A1:A365 and the values are in B1:B365:
=SUMPRODUCT(--(MONTH(A1:A365)=8),B1:B365)
will sum B for August months.
"AG" wrote in message
...
I am using Excel 2000.
I have a very long list of numbers that were entered on a given day during
the year. I want to add all of the numbers that were entered during a
given
month. The date column of my data is formatted with 1/1/05 to 12/31/05.
How
can I select only the numbers entered in a given month and total them for
that month?
--
Alan
--
Dave Peterson
--
Dave Peterson
|