Nested countif function won't work

[flickerfire]

Hi,

COUNTIF is not working. It should count cell with nos. 69,38,8 then multiply it by 50 -

=IF(G17="0", COUNTIF(H17:$H$52,">0")*50,0)


001 3/01/16 $361.12 $- $361.12 3/01/16 $361.12 0 $-
002 4/01/16 $361.12 $- $361.12 4/01/16 $361.12 0 $-
003 5/01/16 $361.12 $- $361.12 5/01/16 $361.12 0 $-
004 6/01/16 $361.12 $- $361.12 6/01/16 $361.12 0 $-
005 7/01/16 $361.12 $- $361.12 7/01/16 $361.12 0 $-
006 8/01/16 $361.12 $- $361.12 8/01/16 $361.12 0 $-
007 9/01/16 $361.12 $- $361.12 9/01/16 $361.12 0 $-
008 10/01/16 $361.12 $- $361.12 69 $361.12
009 11/01/16 $361.12 $- $361.12 38 $361.12
010 12/01/16 $361.12 $- $361.12 8 $361.12
011 1/01/17 $361.12 $- $361.12 (23) $ 0.00
012 2/01/17 $361.12 $- $361.12 (54) $ 0.00
013 3/01/17 $361.12 $- $361.12 (82) $ 0.00
014 4/01/17 $361.12 $- $361.12 (113) $ 0.00

[alansidman]

Upload your spreadsheet so that we can see exactly what your file/cells look like and analyze your issue. In the reply window, scroll down and click on GoAdvanced and follow the wizard.

[Richard Buttrey]

Hi and welcome to the forum
Please upload the workbook. We have no idea how this data appears in your columns.

[flickerfire]

The attach button won't open the path to my folders. Good grief.

Here's the path though - uploaded it in google drive

https://drive.google.com/file/d/0B9F...ew?usp=sharing

[Norie]

Click on GO ADVANCED, scroll down and click Manage Attachments.

[Richard Buttrey]

Yes, there's a problem with the paperclip icon.

You need to Go Advanced and then look below the post area to see the 'Manage Attachments' option.
Select the file and upload it from there.

[scottiex]

If H is the line with 69 in it, isn't G always "$361.12" in this sheet?
So result is always "0"?
maybe you mean to be referring to another column where you say "g17"?

[flickerfire]

There is no Manage Attachment button anywhere.

[Richard Buttrey]

There is no Manage Attachment button anywhere.

You need to choose Reply and then 'Go Advanced', then look below the post

[AliGW]

There is no button, just a hyperlink.

[meabrams]

Try this adjustment (remove "" from around the F1="0")

Please Login or Register  to view this content.

[guru008]

Hi,

"=0" is used in countif not in if statement as 0 is numeric value use =0 instead of "=0"

=IF(F2=0, COUNTIF(G2:$G$37,">0")*50,0)