sumif use
 

Hi,

I want to use sumif in the following way :

SUMIF(purchases!O18:purchases!O500,"=b21",purchase s!
Q18:purchases!Q500)

and not :

SUMIF(purchases!O18:purchases!O500,"=01960",purcha ses!
Q18:purchases!Q500)

in otherwords I want to use the value of the cell b21 to
look up and not the typed in value ( 01960 ) can this be
done ?

thanks

steve

SUMIF(purchases!O18:purchases!O500,"="&B21,purchas es!Q18:purchases!Q500)


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"steve alcock" wrote in message
...
Hi,

I want to use sumif in the following way :

SUMIF(purchases!O18:purchases!O500,"=b21",purchase s!
Q18:purchases!Q500)

and not :

SUMIF(purchases!O18:purchases!O500,"=01960",purcha ses!
Q18:purchases!Q500)

in otherwords I want to use the value of the cell b21 to
look up and not the typed in value ( 01960 ) can this be
done ?

thanks

steve

Hi Andy,

many thanks it works a treat

regards

steve


-----Original Message-----
SUMIF(purchases!O18:purchases!O500,"="&B21,purcha ses!
Q18:purchases!Q500)


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"steve alcock" wrote in
message
...
Hi,

I want to use sumif in the following way :

SUMIF(purchases!O18:purchases!O500,"=b21",purchase s!
Q18:purchases!Q500)

and not :

SUMIF(purchases!O18:purchases!O500,"=01960",purcha ses!
Q18:purchases!Q500)

in otherwords I want to use the value of the cell b21 to
look up and not the typed in value ( 01960 ) can this be
done ?

thanks

steve


.

Why not
=SUMIF(purchases!O18:purchases!O500,B21,purchases! Q18:purchases!Q500)
?
Regareds
"steve alcock" wrote in message
...
Hi Andy,

many thanks it works a treat

regards

steve


-----Original Message-----
SUMIF(purchases!O18:purchases!O500,"="&B21,purch ases!
Q18:purchases!Q500)


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"steve alcock" wrote in
message
...
Hi,

I want to use sumif in the following way :

SUMIF(purchases!O18:purchases!O500,"=b21",purchase s!
Q18:purchases!Q500)

and not :

SUMIF(purchases!O18:purchases!O500,"=01960",purcha ses!
Q18:purchases!Q500)

in otherwords I want to use the value of the cell b21 to
look up and not the typed in value ( 01960 ) can this be
done ?

thanks

steve


.

As a pedagogical exercise???

The OP could see how to change the formula to look for greater than (or any
other comparison operator).

Just my guess.



Alan wrote:

Why not
=SUMIF(purchases!O18:purchases!O500,B21,purchases! Q18:purchases!Q500)
?
Regareds
"steve alcock" wrote in message
...
Hi Andy,

many thanks it works a treat

regards

steve


-----Original Message-----
SUMIF(purchases!O18:purchases!O500,"="&B21,purch ases!
Q18:purchases!Q500)


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"steve alcock" wrote in
message
...
Hi,

I want to use sumif in the following way :

SUMIF(purchases!O18:purchases!O500,"=b21",purchase s!
Q18:purchases!Q500)

and not :

SUMIF(purchases!O18:purchases!O500,"=01960",purcha ses!
Q18:purchases!Q500)

in otherwords I want to use the value of the cell b21 to
look up and not the typed in value ( 01960 ) can this be
done ?

thanks

steve


.


--

Dave Peterson