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$93 5)
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

=SUMIF(Invoices!$C$2:$C$935,A3,Invoices!$J$2:$J$93 5)
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$935D3),Invoices!$J$2:$J$935)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

Thanks Max. Terrific

Ernie

"Max" wrote in message
...
=SUMIF(Invoices!$C$2:$C$935,A3,Invoices!$J$2:$J$93 5)
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$935D3),Invoices!$J$2:$J$935)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

Welcome, Ernie
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Ernie Fenwick" wrote in message
...
Thanks Max. Terrific

Ernie