On Monday, January 28, 2008 at 12:02:34 AM UTC-8, scruffy323 wrote:
Thanks for the help
On Jan 27, 12:52 pm, ilia <[email protected]> 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 <[email protected]> wrote:
On Sat, 26 Jan 2008 13:40:18 -0800 (PST), scruffy323 <[email protected]>
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
If the numbers you want to add are all below 40,000, and the dates are in this decade, then you can use =SUMIF(range,"<40000")
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)