Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Help With SUMIF Function

I have a formula that goes down col. A such that it inserts an "X"
(without quotes) in the cells if a certain criteria is met in data
inserted in other colums.

I am now trying to count how many cells in col. A have the "X" using
the SUMIF function. I keep on getting 0 (zero) as the result.

Here is the formula that I am using in cell B1:

=SUMIF(A1:A10000,"X")

What am I doing wrong?
--
tb
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Help With SUMIF Function

On 8/28/2015 at 8:55:34 AM Claus Busch wrote:

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.


Thanks!!

--
tb
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to nest a left function within a sumif function? LisaK Excel Worksheet Functions 2 April 23rd 23 11:46 AM
Using the TODAY() function in a SUMIF function JPB Excel Worksheet Functions 4 July 27th 06 04:01 PM
How do I use the TODAY function with the SUMIF function? Lisa B. Excel Worksheet Functions 2 September 30th 05 08:51 PM
SUMIF Function Inside SUMPRODUCT Function Abdul Waheed Excel Worksheet Functions 17 September 19th 05 04:24 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 12th 05 12:01 AM


All times are GMT +1. The time now is 07:17 PM.

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

About Us

"It's about Microsoft Excel"