Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sum for two criteria

1 view
Skip to first unread message

Ernie Fenwick

unread,
Dec 3, 2008, 7:37:22 PM12/3/08
to
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

unread,
Dec 3, 2008, 7:51:01 PM12/3/08
to
> =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

unread,
Dec 3, 2008, 8:29:01 PM12/3/08
to
Thanks Max. Terrific

Ernie

"Max" <demec...@yahoo.com> wrote in message
news:C760E5FB-C9C9-4C28...@microsoft.com...

Max

unread,
Dec 3, 2008, 8:38:43 PM12/3/08
to
Welcome, Ernie

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Ernie Fenwick" <fen...@leahall.co.uk> wrote in message
news:eln4N%23aVJH...@TK2MSFTNGP06.phx.gbl...
> Thanks Max. Terrific
>
> Ernie


0 new messages