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: 49
Default I think I know how to ask this sumproduct question now:

This is a sumproduct formula I have worked out to count the number of
recordable events that occurred within a date range.

=SUMPRODUCT((Data!A$2:A$2550=ListValues!A2)*(Data !A$2:A$2550<ListValues!B2)*(Data!H$2:H$2550="Recor dable"))

Now what I am trying to do is capture the cost of these recordable events
(adding another array to sumproduct). These costs are located in cells
Data!K$2:K$2550.

I have not been able to get this $ total by using sumproduct. Somehow I
keep screwing up. The only way I have been able to get this total is by
using conditional sum- but by doing this I am not able to "pull" these
calculations to adjacent cells- and I'm summarizing 20 years of data, so with
each calculation only giving me a month-total, I could be entering the next 3
days if I don't figure this out.

So here's the conditional-sum formula that gives the total- but that I have
to enter each time:

=SUM(IF(Data!$A$2:$A$2500=ListValues!A2,IF(Data!$ H$2:$H$2500=A19,IF(Data!$A$2:$A$2500<ListValues!B2 ,Data!$K$2:$K$2500,0),0),0))

Is it possible to get to this total with SumProduct?



 
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
Sumproduct question pdberger Excel Worksheet Functions 4 December 13th 07 08:24 PM
Sumproduct question Brad Excel Worksheet Functions 2 November 1st 06 07:32 PM
SUMPRODUCT question Barb Reinhardt Excel Worksheet Functions 9 October 2nd 06 01:42 PM
SUMPRODUCT Question.... Jeremy Ellison Excel Worksheet Functions 5 December 9th 05 12:56 AM
SUMPRODUCT question Daniel Bonallack Excel Worksheet Functions 4 November 29th 04 02:03 PM


All times are GMT +1. The time now is 04:24 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"