| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count # of times a Reference is used
I have a spreadsheet like the following:
A B C D E 1 CustID Ref # Inv # Paid Inv. Date No. of dist. 2 James Check #123 101 01/01/05 1 3 Mary Visa123 343 02/03/05 2 4 Mary Visa123 345 02/03/05 2 5 Buger /RR123 456 01/09/05 3 6 Buger /RR123 457 01/09/05 3 7 Buger /RR123 458 01/09/05 3 I need a formula or functions, or whatever that will count how many times a check, visa or whatever ref # and put that count in the "No. of Distributions" column. That same number has to be on each line associated with that "reference #". I am sure there is a way. I tried the subtotal - using the count but it doesnt total in the "no. of distributions column". Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep. Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night. Please Please Help!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of times a Reference is used
I almost forgot this file will end up as a .csv to be imported into another
program. "klafert" wrote: I have a spreadsheet like the following: A B C D E 1 CustID Ref # Inv # Paid Inv. Date No. of dist. 2 James Check #123 101 01/01/05 1 3 Mary Visa123 343 02/03/05 2 4 Mary Visa123 345 02/03/05 2 5 Buger /RR123 456 01/09/05 3 6 Buger /RR123 457 01/09/05 3 7 Buger /RR123 458 01/09/05 3 I need a formula or functions, or whatever that will count how many times a check, visa or whatever ref # and put that count in the "No. of Distributions" column. That same number has to be on each line associated with that "reference #". I am sure there is a way. I tried the subtotal - using the count but it doesnt total in the "no. of distributions column". Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep. Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night. Please Please Help!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of times a Reference is used
Hi!
Looks like this should work: =COUNTIF(B$2:B$7,B2) Copy down as needed. Adjust references to suit. Biff "klafert" wrote in message ... I have a spreadsheet like the following: A B C D E 1 CustID Ref # Inv # Paid Inv. Date No. of dist. 2 James Check #123 101 01/01/05 1 3 Mary Visa123 343 02/03/05 2 4 Mary Visa123 345 02/03/05 2 5 Buger /RR123 456 01/09/05 3 6 Buger /RR123 457 01/09/05 3 7 Buger /RR123 458 01/09/05 3 I need a formula or functions, or whatever that will count how many times a check, visa or whatever ref # and put that count in the "No. of Distributions" column. That same number has to be on each line associated with that "reference #". I am sure there is a way. I tried the ubtotal - using the count but it doesn't total in the "no. of distributions column". Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep. Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night. Please Please Help!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of times a Reference is used
=COUNTIF($B$2:$B$100,,B2)
copy down replace the range with your range and B2 with the first cell you want to count -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "klafert" wrote in message ... I have a spreadsheet like the following: A B C D E 1 CustID Ref # Inv # Paid Inv. Date No. of dist. 2 James Check #123 101 01/01/05 1 3 Mary Visa123 343 02/03/05 2 4 Mary Visa123 345 02/03/05 2 5 Buger /RR123 456 01/09/05 3 6 Buger /RR123 457 01/09/05 3 7 Buger /RR123 458 01/09/05 3 I need a formula or functions, or whatever that will count how many times a check, visa or whatever ref # and put that count in the "No. of Distributions" column. That same number has to be on each line associated with that "reference #". I am sure there is a way. I tried the ubtotal - using the count but it doesn't total in the "no. of distributions column". Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep. Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night. Please Please Help!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of times a Reference is used
Oops! I managed to get an extra comma in there somehow, should be one comma
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Peo Sjoblom" wrote in message ... =COUNTIF($B$2:$B$100,,B2) copy down replace the range with your range and B2 with the first cell you want to count -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "klafert" wrote in message ... I have a spreadsheet like the following: A B C D E 1 CustID Ref # Inv # Paid Inv. Date No. of dist. 2 James Check #123 101 01/01/05 1 3 Mary Visa123 343 02/03/05 2 4 Mary Visa123 345 02/03/05 2 5 Buger /RR123 456 01/09/05 3 6 Buger /RR123 457 01/09/05 3 7 Buger /RR123 458 01/09/05 3 I need a formula or functions, or whatever that will count how many times a check, visa or whatever ref # and put that count in the "No. of Distributions" column. That same number has to be on each line associated with that "reference #". I am sure there is a way. I tried the btotal - using the count but it doesn't total in the "no. of distributions column". Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep. Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night. Please Please Help!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of times a Reference is used
Thank you SO VERY MUCH!!!!! YOU ARE A GENIIUSA!!!!!
"Peo Sjoblom" wrote: Oops! I managed to get an extra comma in there somehow, should be one comma -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Peo Sjoblom" wrote in message ... =COUNTIF($B$2:$B$100,,B2) copy down replace the range with your range and B2 with the first cell you want to count -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "klafert" wrote in message ... I have a spreadsheet like the following: A B C D E 1 CustID Ref # Inv # Paid Inv. Date No. of dist. 2 James Check #123 101 01/01/05 1 3 Mary Visa123 343 02/03/05 2 4 Mary Visa123 345 02/03/05 2 5 Buger /RR123 456 01/09/05 3 6 Buger /RR123 457 01/09/05 3 7 Buger /RR123 458 01/09/05 3 I need a formula or functions, or whatever that will count how many times a check, visa or whatever ref # and put that count in the "No. of Distributions" column. That same number has to be on each line associated with that "reference #". I am sure there is a way. I tried the btotal - using the count but it doesn't total in the "no. of distributions column". Need help ASAP!!!! Need answer 2nite - need to finished so I can sleep. Been up since 12:45 a.m. Went to be at 10 p.m. Saturday night. Please Please Help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count how many times an Excel workbook has been accessed | Excel Discussion (Misc queries) | |||
| How can I reference a cell as the criteria in a count if function. | Excel Discussion (Misc queries) | |||
| How do I count the # of times a value reoccurs and plot it over ti | Charts and Charting in Excel | |||
| How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Linear Mode
