Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Dukker Jansen   on Sep 02 In MS Office Category.

  
Question Answered By: Brooke Robertson   on Sep 02

There will be more elegant ways to accomplish this, but as a quick fix do
the following.



In 3 cells that are not being used, Just enter the formula
=if(subtotal1=0,1,0)

Change subtotal 1 for each of the subtotals/cell references concerned.

You can simply do a =sum(subtotal1:subtotal3) to accomplish your target
count.

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Excel 2000 Sumif/Countif Or get search suggestion and latest updates.


Tagged: