Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Count formula

Hi All,

I have the following data:

Product Month
A 1
B 1
C 1
A 2
B 3
A 4
B 7
C 2
D 3
B 1
C 2
D 9

Could you please provide me the formula to count A, B, C, and D with below
conditions:
<2 months 2 - 6 months 6 months
A count= ? ? ?
B ? ? ?
C ? ? ?
D ? ? ?

Thanks & regards,


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Formula - Count Ticks LittleAnn Excel Discussion (Misc queries) 3 May 8th 23 07:44 PM
Count Formula alish Excel Discussion (Misc queries) 5 June 10th 08 08:58 PM
is there a formula to count something like this.... driller Excel Worksheet Functions 3 July 6th 07 07:16 PM
Trying to construct a count count formula Chris K Excel Discussion (Misc queries) 6 May 26th 07 07:20 PM
a count formula TMF in MN Excel Worksheet Functions 3 August 14th 06 08:53 PM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"