How do I do a total across multiple sheets? I can't get this to work.
Thanks.
"Bob Phillips" wrote:
More than 10% quicker
=SUMPRODUCT(--($A$1:$F$1="y"),--($A$2:$F$2="y"))
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Rick Rothstein (MVP - VB)" wrote in
message ...
Give this a try...
=SUMPRODUCT(--(A1:F1&A2:F2="yy"))
Rick
"twototango" wrote in message
...
I have several sheets setup from which I need to caluculate: how many of
the
cells in a range meet both criteria. It's setup something like the
below:
A B C D E F....
1 y y n n y y
2 n y n y y n
I need to determine how many "y" in range A1:F1 that are also "y" in
A2:F2
across multiple sheets.
Thanks!