how do i set a formulas with two conditions using countif

hello

i have a problem with formulas containing two conditions i tried sumif and
countif but it's not working
=COUNT(IF((sheet1!$F$8:$F$300="Materials")*(sheet1!$M$8:$M$300="PPE not
available"),sheet1!$A:$N))

appreciate your help in advnace
thanks

To count the number of rows with "Materials" in column F and "PPE not
available" in column M, you could use the DCOUNT function (which requires
setting up a couple of rows for the criteria) or the SUMPRODUCT:
=sumproduct(--(sheet1!$F$8:$F$300="Materials"),--(sheet1!$M$8:$M$300="PPE
not available"))
To add up the associated values from column N where the same criteria are
met, you'd switch to DSUM, or add that array from column N to the sumproduct
formula:
=sumproduct(--(sheet1!$F$8:$F$300="Materials"),--(sheet1!$M$8:$M$300="PPE
not available"),sheet1!$N$8:$N$300)


"kiko31" wrote:

> hello
>
> i have a problem with formulas containing two conditions i tried sumif and
> countif but it's not working
> =COUNT(IF((sheet1!$F$8:$F$300="Materials")*(sheet1!$M$8:$M$300="PPE not
> available"),sheet1!$A:$N))
>
> appreciate your help in advnace
> thanks
>
>

=SUMPRODUCT(--(Sheet1!$F$8:$F$300="Materials"),
--(Sheet1!$M$8:$M$300="PPE not available"))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"kiko31" <kiko31@discussions.microsoft.com> wrote in message
news:3BEBC227-42B4-447A-84AD-A284C1E0A8A9@microsoft.com...
> hello
>
> i have a problem with formulas containing two conditions i tried sumif
and
> countif but it's not working
> =COUNT(IF((sheet1!$F$8:$F$300="Materials")*(sheet1!$M$8:$M$300="PPE not
> available"),sheet1!$A:$N))
>
> appreciate your help in advnace
> thanks
>
>

many thanks for your propmt help it's work

"Bob Phillips" wrote:

> =SUMPRODUCT(--(Sheet1!$F$8:$F$300="Materials"),
> --(Sheet1!$M$8:$M$300="PPE not available"))
>
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "kiko31" <kiko31@discussions.microsoft.com> wrote in message
> news:3BEBC227-42B4-447A-84AD-A284C1E0A8A9@microsoft.com...
> > hello
> >
> > i have a problem with formulas containing two conditions i tried sumif
> and
> > countif but it's not working
> > =COUNT(IF((sheet1!$F$8:$F$300="Materials")*(sheet1!$M$8:$M$300="PPE not
> > available"),sheet1!$A:$N))
> >
> > appreciate your help in advnace
> > thanks
> >
> >
>
>
>