View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave_in_gva Dave_in_gva is offline
external usenet poster
 
Posts: 9
Default Summing on year and text conditions

Check. Tx again.

In case you have time/interest/ability I have posted another query in this
forum with the title New worksheets in webquery.xls not automatically
refreshing....awaiting help with this eagerly if possible.

Thanks again for your help with this query.

Dave

"Max" wrote:

No prob. Glad you figured it out.
You can omit the zero in the tweak
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Dave_in_gva" wrote in message
...
Sorry Max....forget my stupid question. Just figured it out myself and did
so
by adding =0-(your formula).