Thanks for the help
On Jan 27, 12:52 pm, ilia <iasaf...@gmail.com> wrote:
You could do some kind of sanity check formula. For instance,
SUMPRODUCT(2:2,--(YEAR(2:2)>1945))
It would only be reliable for sample values you provided such as 123
and 234, but depending on your situation it may work. For example, if
you are pretty sure you won't have numbers between 32,874.00 and
40,179.00, then you can fairly safely use this kind of conditional sum
for dates between 1/1/1990 and 1/1/2010.
On Jan 26, 9:08 pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
On Sat, 26 Jan 2008 13:40:18 -0800 (PST), scruffy323 <steve.mo...@gmail.com>
wrote:
I am looking to sum entries in a column that are not a date.
So for this row I would like to get the sum 357
| Column:A | Column:B | Column:C | Column:D |
ROW:2 | 1/1/2008 | 234 | 1/2/2008 | 123 |
I want to do something like >sumif(A2:2,isnumber(currentcellsomehow),A2:2)
Does any one know how this is possible, I have been reading posts on >the web but can't find anything like this.
Steve
I don't think that, by using a formula, you can reliable differentiate between
a number and a date. This is because Excel stores dates as numbers.
However, if you wanted to add all the even columns in row 2 (e.g. B2, D2, F2,
etc), you could use this formula:
=SUMPRODUCT(2:2,--(MOD(COLUMN(2:2),2)=0))
--ron
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 303 |
Nodes: | 16 (0 / 16) |
Uptime: | 10:02:22 |
Calls: | 6,796 |
Calls today: | 4 |
Files: | 12,317 |
Messages: | 5,393,641 |
Posted today: | 1 |