Thread
:
CSE Formula
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
CSE Formula
glad to help
--
Don Guillett
SalesAid Software
"gregory" wrote in message
...
Don,
Thank you very much. This worked!!
gregory
"Don Guillett" wrote:
try
code={"test","live"}
--
Don Guillett
SalesAid Software
"gregory" wrote in message
...
In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and
Amount
are ranges.
What sign is used for OR? What I'm trying to do is sum the values in
the
"Amount" range if Code="test" OR Code="live" AND Acct="Recon"
Thanks,
gregory
Reply With Quote