Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |