Sum for two criteria

[Ernie Fenwick]

Hi

I am trying to add figures from Invoices workseet into a Summary worksheet.
I have it working for 1 set of criteria as follows
=SUMIF(Invoices!$C$2:$C$935,A3,Invoices!$J$2:$J$935)
I also want to add for a date in col I in Invoices greater than col D in the
summary sheet

Thanks for any help

Ernie

 

[Max]

=SUMIF(Invoices!$C$2:$C$935,A3,Invoices!$J$2:$J$935)

I also want to add for a date in col I in Invoices
greater than col D in the summary sheet

Assuming real dates in col I in Invoices and in col D in the summary sheet:
=SUMPRODUCT((Invoices!$C$2:$C$935=A3)*(Invoices!$I$2:$I$935>D3),Invoices!$J$2:$J$935)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

 

[Ernie Fenwick]

Thanks Max. Terrific

Ernie

Assuming real dates in col I in Invoices and in col D in the summary
sheet:
=SUMPRODUCT((Invoices!$C$2:$C$935=A3)*(Invoices!$I$2:$I$935>D3),Invoices!$J$2:$J$935)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

 

[Max]

Welcome, Ernie
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik