View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 1
Default Need help with formula.

Hello,

I am trying to find a formula that will count selected information.
For instance, I have a spreadsheet that has multiple data with many
different columns. However, I am only interested at counting all the
transactions that took place on 10/30/06, West Region, O, Jane placed
on this date.

A B C D
Date Region Descripion Name
10/28/06 North Q Frank
10/28/06 West O Jane
10/29/06 East O Bill
10/29/06 East O Jane
10/29/06 West Q Jane
10/30/06 West O Jane


The total should equal 1.

Any guidance is truly appreciated.

Regards,
Joe