Excel help with counting

  wiznyme 17:43 17 Mar 2008

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 2008

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.

Elsewhere on IDG sites

AMD Ryzen news - release date, UK price, features and specifications

The pulp art of 80s computer game magazine covers

Best value Mac: Which is the best £1249 Mac to buy

Comment faire des captures d’écran sous Windows 10 ?