LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KK KK is offline
external usenet poster
 
Posts: 61
Default Counting colums with '0' in Excel

I need to count the number of weeks a particular column is '0' starting from
week 12 and going towards week 1 and display the total under the first N.
After this I need to count the number of weeks it remained positive and then
display this figure under P. on the same row I then again need to count the
number of weeks when the the figure remained '0' and display under N on the
extreme right.
given below is an example:

Week 1 2 3 4 5 6 7 8 9 10 11 12
N P N
Product-A 0 0 5 0 0 0 0 4 1 3 0 0
2 3 4
Product-B 0 0 0 0 0 3 0 0 1 0 0 0
3 1 2


Thanks for all your support
 
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
I am new to excel and to multiply three colums together then add ntobias New Users to Excel 6 August 25th 06 04:53 PM
In Excel the colums which used to be A,B,C D etc are now 1,2,3 Dave Lock Excel Discussion (Misc queries) 3 May 9th 06 03:16 PM
Counting different colums gadget New Users to Excel 1 November 8th 05 02:06 PM
i want my excel colums to be rows peter Excel Worksheet Functions 1 March 29th 05 10:37 PM
How do I name my colums in Excel ? Kath New Users to Excel 1 February 3rd 05 01:00 AM


All times are GMT +1. The time now is 03:45 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"