View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Kirill V Kirill V is offline
external usenet poster
 
Posts: 5
Default ISNUMBER Logical test

Thanks Mike... for some reason pulls in Zero. Just to clarify, all my
contitions need to be met in the SUM. Column B has to begin with 312, or
313, Column K must contain CT08 and Column R must contain B60... only
then sum column H.

You can copy & Paste the below into excel... thats my sample.

Ldgr Account Period Trans Date Journal Line Base Amt Base Amt
(+/-) D/C Reference Description
A 410-100250 2009002 20090213 AAA 112 0.02 0.02 D CC CT0360
A 415-000000 2009002 20090217 AAA 112 0.02 0.02 D CC CT0360
A 312-000000 2009002 20090217 AAA 112 0.02 -0.02 C CC CT0860
A 313-000000 2009002 20090202 AAA 112 43290 43290 D CC CT0360
A 313-000000 2009002 20090202 AAA 112 279542.6 -279542.6 C CC CT0360
A 313-000000 2009002 20090202 AAA 112 517.08 517.08 D CC CT0360
A 313-000000 2009002 20090202 AAA 112 1165946.73 1165946.73 D CC CT0360
A 313-000000 2009002 20090202 AAA 112 436670.7 -436670.7 C CC CT0360
A 313-000000 2009002 20090202 AAA 112 87377.74 -87377.74 C CC CT0860
A 313-000000 2009002 20090202 AAA 112 631312.56 -631312.56 C CC CT0360
A 313-000000 2009002 20090202 AAA 112 61631.5 -61631.5 C CC CT0360
A 313-000000 2009002 20090202 AAA 112 702887.96 702887.96 D CC CT0860


*** Sent via Developersdex http://www.developersdex.com ***