Thread: Help With SUMIF Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Help With SUMIF Function
Hi,

Am Fri, 28 Aug 2015 13:49:37 +0000 (UTC) schrieb tb:

=SUMIF(A1:A10000,"X")

try:
=COUNTIF(A1:A10000,"X")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote