Re: SUMIF - 2 conditions - with references
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Tue, 20 Sep 2005 22:49:59 -0400
Hi!
Try this:
Real dates are just numbers formatted to look like dates.
9/20/2005 is really the numeric value 38615 formatted to look like 9/20/2005
Make sure CREDIT!$A4 is a real date.
=ISNUMBER(CREDIT!$A4) should return TRUE
Try to find corresponding cells in your range that match each criteria:
Y200 = 26
AJ200 = CREDIT!$A4
=ISNUMBER(Y200) should return TRUE
=ISNUMBER(AJ200) should return TRUE
Assume AJ200 "matches" the date entered in CREDIT!$A4
=AJ200=CREDIT!$A4 should return TRUE
Biff
"vect98" <vect98.1vos6a_1127268308.5461@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:vect98.1vos6a_1127268308.5461@xxxxxxxxxxxxxxxxxxxxxxxx
>
> hey thanks for your help, i converted both columns to numbers but it
> still doesnt work , just comes up with 0 which it shouldnt. the 26 is
> one condition the other condition is a date, so maybe that is affecting
> it??
>
>
> --
> vect98
> ------------------------------------------------------------------------
> vect98's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=26365
> View this thread: http://www.excelforum.com/showthread.php?threadid=469366
>
.
- Follow-Ups:
- Re: SUMIF - 2 conditions - with references
- From: vect98
- Re: SUMIF - 2 conditions - with references
- Prev by Date: Re: NORMDIST(x,mean, stdev,false) vs f(x)
- Next by Date: I need help
- Previous by thread: Re: NORMDIST(x,mean, stdev,false) vs f(x)
- Next by thread: Re: SUMIF - 2 conditions - with references
- Index(es):
Relevant Pages
|
