LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Conditional Sum

I have a worksheet that has many conditional sum functions in it. The array
is exported data out of an accounting program. The formating is the same
between the criteria and the range however I can not seem to get it to work
when I export new data it just comes back with the answer of zero which is
incorrect. I have other worksheets with the same set up except one of the
criteria has letters and numbers in the criteria and they work fine. In the
worksheet that does not work that same criteria is just numbers. Can someone
help me with this issue?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Rank (or rather, Conditional Range) [email protected] Excel Worksheet Functions 6 April 16th 07 06:15 PM
Is IF() Conditional the way to do this? Lorne Oliver Excel Worksheet Functions 9 July 5th 06 06:47 PM
Conditional Sum randys Excel Discussion (Misc queries) 3 September 16th 05 02:08 AM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM
Conditional IF Jon1205 Excel Discussion (Misc queries) 4 July 28th 05 11:25 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"