Excel 2007: complex COUNTIFS()
COUNTIFS can't do that. Try this:
=SUMPRODUCT(--(H1:H25-G1:G25=5))
--
Biff
Microsoft Excel MVP
"David Aukerman" wrote in message
...
PJ,
What I'd like to do is this:
=COUNTIFS(H:H - G:G, 5)
(There are other criteria I'm checking at the same time, which is why I'm
using COUNTIFS().) The idea is that I want to check that the difference
between columns H and G is 5. Does that help?
--David
"PJFry" wrote:
It is unclear to me where the criteria comes in. Is it supposed to be
Count
if the difference is 5 (or something like that)?
--
Regards,
PJ
|