Sum with name criteria and date range>

[destra1]

Hi,
I am trying to create an array formula to sum totals if the name match criteria is met as well as being within certain dates.

=SUM(IF(G4:G10,"A26:A45",IF(C4:C10="Name",'F4:F10)))

G=date entered by user
A=My date list
C=Name of product
F=Dollar value (non constant)

Eg. I want to know the total dollars collected in a period of time for a given product. But with the above formaula I only get a zero return! Can anyone help me?!!!

 

[Aladin Akyurek]

Care to post a sample along with conditions that must hold and desired results?

 

[destra1]

[HTML removed by Von Pookie]

 

[destra1]

As I ma at work, I am limited to do the add in for the HTML Maker to show you a copy of what I was looking for

 

[Guentjo]

you should use sumproduct. Tips on sumproduct are all over this board.

 

[Aladin Akyurek]

As I ma at work, I am limited to do the add in for the HTML Maker to show you a copy of what I was looking for

When using HtmlMaker, one should not attempt to post as much data as possible. Rather, try to think in terms of a tiny sample that illustrates the problem you want solve. An example of how to go about it:

A1:A3 ==> Dan, Jon, Jon
B1:B3 ==> 5, 8, 9

Needed: Total for Jon, which is: 17.