Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula.
Hi there,
I placed your data (excluding headers) in A3:D8. I then put your criteria in A1:D1 (10/30/06, West Region, O, Jane) Then put this in a cell somewhere on the sheet: =SUMPRODUCT(--(A3:A8=A1),--(B3:B8=B1),--(C3:C8=C1),--(D3:D8=D1)) You'll get a count of 1 with the data you gave. If you insert another line in the middle and copy the last line in there, you'll increase to 2. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca Joe wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula.
This can easily be managed with a pivot table. Put the date, region,
description and name on the page portion of the table, put the name field on the data field and selct count on field settings. Gary "Joe" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |