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

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).