Sum with name criteria and date range>

destra1

New Member
Joined
Dec 28, 2005
Messages
3
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?!!!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

destra1

New Member
Joined
Dec 28, 2005
Messages
3
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

Active Member
Joined
Jul 27, 2004
Messages
347
you should use sumproduct. Tips on sumproduct are all over this board.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
destra1 said:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,035
Messages
5,569,784
Members
412,292
Latest member
The Bear named Joe
Top