Excel help with counting

  wiznyme 17:43 17 Mar 08

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

I've tried sumproduct & countif


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 *.



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