mmm or mmmm in that =text() portion?

But if the criteria don't match--Invoices!J2:J2000 has to be text--not a real
date.

And invoices!A2:A2000 has to be text, too.

Ilse wrote:

Ok thanks so far, at least it stops erroring now. Now to get a number instead
of zero. The sum is not zero, I will try and tweek it.

Thanks so much so far !

"Toppers" wrote:

I think you need SUMPRODUCT:

=SUMPRODUCT(--(Invoices!$J2:$J2000=TEXT(E1,"mmm-yyyy")),--(Invoices!A2:A2000=TEXT(A21,"00000000")),Invoices! F2:F2000)

HTH

"Ilse" wrote:

I would like to combine the following 2 formulas into 1 formula, yet I can't
seem to find the correct way to do it, if it is possible.

=SUMIF(Invoices!$J:$J,"="&(TEXT(E1,"mmmmmmmmm-yyyy")),Invoices!F2:F2000)
=SUMIF(Invoices!A2:A2000,"="&(TEXT(A21,"00000000") ),Invoices!F2:F2000)

In short I want this cell to check a list of invoices and display everything
by month and by account code. I would have to look at column A for the
account code and column J for the date. In the master sheet I want an
overview per month per account.

I would appreciate any help.


I would appreciate any help.

--

Dave Peterson