I am trying to set up a function which looks to see if multiple criteria,
across different columns are met.
Idealy I should think the following function should work, but alas, it does
not:
=COUNTIF(AND(A1:A5=1, B1:B5=2))
Any suggestions?
I am trying to set up a function which looks to see if multiple criteria,
across different columns are met.
Idealy I should think the following function should work, but alas, it does
not:
=COUNTIF(AND(A1:A5=1, B1:B5=2))
Any suggestions?
=SUMPRODUCT((A1:A5=1)*(B1:B5=2)*(C1:C5=3)) etc
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"DJ_Swammi" <[email protected]> wrote in message
news:[email protected]...
>I am trying to set up a function which looks to see if multiple criteria,
> across different columns are met.
>
> Idealy I should think the following function should work, but alas, it
> does
> not:
>
> =COUNTIF(AND(A1:A5=1, B1:B5=2))
>
> Any suggestions?
Check this site for using SUMPRODUCT for calculations involving multiple
criteria:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Another means is using the DCOUNT function.
"DJ_Swammi" wrote:
> I am trying to set up a function which looks to see if multiple criteria,
> across different columns are met.
>
> Idealy I should think the following function should work, but alas, it does
> not:
>
> =COUNTIF(AND(A1:A5=1, B1:B5=2))
>
> Any suggestions?
Thank you, this has been very helpful!
You're welcome :-)
"DJ_Swammi" <[email protected]> wrote in message
news:[email protected]...
> Thank you, this has been very helpful!
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks