[SOLVED] How to Get Blank as result

Hi Guy,

I am using formula "SUMIFS" to produce certain information as a result. However i just notice there is 1 data of which formula read error and project the wrong result due to data is blank.

Is there any formula i need to adjust to get Blank as result ?

Please share some knowledge of it. Attached together sample for easy understanding of my request

Thanks

LEN($B$3) =? or =< or something. Logical_test required

Sorry I didn't get it,

I did try the logical test you suggest, but still error

IF(logical_test,A,B)

if logical_test = true , display A, pass over (don't check) B
if logical_test = false, display B, pass over (don't check) A

if you delete or change your data , you change also true to false or false to true. It depends of operator (=,<>,=<,=>) in your IF function

correct logical_test is required.

or get it.

The B3 is formula to count month.

How about just ignore/delete the B3 data

just use this

=SUMIFS(Test!$C$3:$C$500,Test!$A$3:$A$500,">="&$B$1,Test!$A$3:$A$500,"<="&$B$2,Test!$B$3:$B$500,A8)

i still get 0.00% as result.

hi rino,

So i need to add another formula to read. Good idea

I change your example by adding a new column
if found the row that match the condition, and I replace your formula, in the new formula I verify if the value is blank.

I give a bad file, here the good one

Yes, that is the issue.
The logical test is always TRUE. That is why the result appeared as number "0" instead.

To confuse.

Is there any formula function i should use instead "SUMPRODUCT" function ?

______________________________

Rino,
Is still the same result as mine

Every formula has the same mistake. No logical_test.

=IF(LEN($B$3),SUMIFS(Test!$C$3:$C$500,Test!$A$3:$A$500,">="&$B$1,Test!$A$3:$A$500,"<="&$B$2,Test!$B$3:$B$500,A9),"")

IF(raining=yes, i will stay at home, else I will go for a walk)

checkin'... I see sun so.... I am going for a walk

You need to define condition when your formula should show % or "blank" becaue now condition is always true.

FDibbins, are you sure?

guys,
like i said, just ignore the B3 data

this is update excel. any formula to get Blank as result ?

I like this forum, as we share idea and understand new thing.

Put into D8

=IF(SUMIFS(Test!$C$3:$C$500,Test!$A$3:$A$500,">="&$B$1,Test!$A$3:$A$500,"<="&$B$2,Test!$B$3:$B$500,A8)<>0,SUMIFS(Test!$C$3:$C$500,Test!$A$3:$A$500,">="&$B$1,Test!$A$3:$A$500,"<="&$B$2,Test!$B$3:$B$500,A8),"")

I made assumption about SUMIF<>0 show something else show nothing

Try this one.....


regards

Ups I got big lag from the forum. Sorry FDibbins