View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bryan Bryan is offline
external usenet poster
 
Posts: 114
Default How do I use DCOUNT with evaluation of multiple columns?

Wow. Thank you very much!

"Teethless mama" wrote:

Take a look COUNTIFS function in help menu


"Bryan" wrote:

I am running Excel 2007.

I have a spreadsheet with 7 fields (columns). I want to count the number of
rows where field 2 is a specific value AND filed 5 is a specific value (or
non-blank). I do not understand the instructions provided in DCOUNT help
under "Multiple criteria in multiple columns where all criteria must be true".

Thanks!