Meeting two conditions before summing

=SUMPRODUCT(--(A12:A100=M1),--(C2:C100=""), B2:B100)

--
HTH

Bob Phillips

"Andeb" <Andeb@discussions.microsoft.com> wrote in message
news:8F4B1EE3-C1E5-4545-9C5C-6EA6EEFC9274@microsoft.com...
> Hi,
>
> I'm a bit if a newbie....
>
> How can I sum only those cells that match 2 criteria (the company name
cell
> on the left of the $ figure to be added must = a reference cell AND the
date
> cell on the right must be blank)
>
> This is a simple(?) spreadsheet that allows me to select a specific
customer
> and shows me the outstanding debt (ie the date cell is empty because they
> didnt pay on x date)

=SUMPRODUCT(--(A12:A100=M1),--(C2:C100=""), B2:B100)

--
HTH

Bob Phillips

"Andeb" <Andeb@discussions.microsoft.com> wrote in message
news:8F4B1EE3-C1E5-4545-9C5C-6EA6EEFC9274@microsoft.com...
> Hi,
>
> I'm a bit if a newbie....
>
> How can I sum only those cells that match 2 criteria (the company name
cell
> on the left of the $ figure to be added must = a reference cell AND the
date
> cell on the right must be blank)
>
> This is a simple(?) spreadsheet that allows me to select a specific
customer
> and shows me the outstanding debt (ie the date cell is empty because they
> didnt pay on x date)

Hi,

I'm a bit if a newbie....

How can I sum only those cells that match 2 criteria (the company name cell
on the left of the $ figure to be added must = a reference cell AND the date
cell on the right must be blank)

This is a simple(?) spreadsheet that allows me to select a specific customer
and shows me the outstanding debt (ie the date cell is empty because they
didnt pay on x date)

=SUMPRODUCT(--(A12:A100=M1),--(C2:C100=""), B2:B100)

--
HTH

Bob Phillips

"Andeb" <Andeb@discussions.microsoft.com> wrote in message
news:8F4B1EE3-C1E5-4545-9C5C-6EA6EEFC9274@microsoft.com...
> Hi,
>
> I'm a bit if a newbie....
>
> How can I sum only those cells that match 2 criteria (the company name
cell
> on the left of the $ figure to be added must = a reference cell AND the
date
> cell on the right must be blank)
>
> This is a simple(?) spreadsheet that allows me to select a specific
customer
> and shows me the outstanding debt (ie the date cell is empty because they
> didnt pay on x date)