Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 24th 05, 11:32 AM
wayne75
 
Posts: n/a
Default COUNTIF and then SUM in Same Function


Can anybody tell me if I can do a countif and then within the same
formula do a basic sum i.e. Subtract 1 from the countif result (All
within the same cell).

Any help greatly appreciated

Many Thanks

Wayne


--
wayne75
------------------------------------------------------------------------
wayne75's Profile: http://www.excelforum.com/member.php...o&userid=23669
View this thread: http://www.excelforum.com/showthread...hreadid=373447


  #2   Report Post  
Old May 24th 05, 11:38 AM
mangesh_yadav
 
Posts: n/a
Default


=COUNTIF(A1:A10,"a")-1

counts the occurance of string "a" in the range A1:A10 and then
subtracts 1 from it.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=373447



Reply
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



All times are GMT +1. The time now is 10:12 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017