View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Aukerman[_2_] David Aukerman[_2_] is offline
external usenet poster
 
Posts: 14
Default Excel 2007: complex COUNTIFS()

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