Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default SUMPRODUCT Returning 0 or wrong totals

I have been trying to figure this out for 3 days.
I have 2 criterias that need to be met and then I want the total of a column.

A

C

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,522
Default SUMPRODUCT Returning 0 or wrong totals

As ALWAYS, post your efforts for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rbirdie" wrote in message
...
I have been trying to figure this out for 3 days.
I have 2 criterias that need to be met and then I want the total of a
column.

A

C


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default SUMPRODUCT Returning 0 or wrong totals

Sorry Don- Hit enter in error. Resubmitted with details.

"Don Guillett" wrote:

As ALWAYS, post your efforts for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rbirdie" wrote in message
...
I have been trying to figure this out for 3 days.
I have 2 criterias that need to be met and then I want the total of a
column.

A

C


.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,522
Default SUMPRODUCT Returning 0 or wrong totals

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rbirdie" wrote in message
...
Sorry Don- Hit enter in error. Resubmitted with details.

"Don Guillett" wrote:

As ALWAYS, post your efforts for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rbirdie" wrote in message
...
I have been trying to figure this out for 3 days.
I have 2 criterias that need to be met and then I want the total of a
column.

A

C


.


Reply
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
Formula returning wrong answer Jeff Gross Excel Worksheet Functions 1 September 16th 07 01:04 AM
Formula returning wrong answer Max Excel Worksheet Functions 1 September 14th 07 04:12 PM
Formula returning wrong result. Steve Hunt Excel Worksheet Functions 1 December 2nd 06 09:10 AM
why does auto sum get wrong totals? Monte Excel Worksheet Functions 1 February 1st 06 02:12 AM
VLOOKUP returning wrong row jthomas Excel Worksheet Functions 6 August 3rd 05 10:32 PM


All times are GMT +1. The time now is 02:14 PM.

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

About Us

"It's about Microsoft Excel"