Excel help with counting

  wiznyme 17:43 17 Mar 08
Locked

Hi, I need to be able to count the rows in an excel spreadsheet that match 2 conditions.

I've tried sumproduct & countif

=SUMPRODUCT((Edited!D:D="x")*(Edited!E:E="y"))
=COUNTIF((Edited!D:D="x")*(Edited!E:E="y"))

hope this is clear & thanks in advance for any help.

  VoG II 17:47 17 Mar 08

Unless you are using Excel 2007 you can't use whole column references with SUMPRODUCT. Just make sure that each range is the same size. Also -- is less 'expensive' for coercion than *.

Try

=SUMPRODUCT(--(Edited!D1:D1000="x"),--(Edited!E1:E1000="y"))

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos