Sumifs formula to sum non-blank where the criteria range has blanks with formulas

[yossip]

hi,
I am trying to write a sumifs formula to sum values where the crteria range is text derived from formula.

I am trying to sum all the rows that are not blank.
all rows in column B have formulas.

see example

sum range crtiria range formula in column B
1 sun "=IF($A2=2,"","sun")"
2 "=IF($A3=2,"","sun")"
2 "=IF($A4=2,"","sun")"
1 sun "=IF($A5=2,"","sun")"

Thanks,

[Sam Capricci]

you want countif for that, like =COUNTIF(A:A,"sun")

or whatever column that has "sun" in it as a result.

[yossip]

I need a formula to sum all non blank .
putting the text in the sumifs function will not help when there will hundreds of different texts in column B

[Gregb11]

uploading a file (like it says in the yellow banner at the top will go a long way in helping you.

[Sam Capricci]

are you talking about summing column A where you either have 2 or some other value or blanks?
that is different from what you wrote in post #1.
Because you are saying your formula in col B is =IF(A2=2,"","sun")
There is no way to sum "sun" which is a text. That is why I said you can count them unless your plan is to sum column A or you are assigning a value to sun?
Please mock up a simple workbook following the instructions in the banner at the top and post a small sample WITH expected results so we better understand.

EDIT: you can count the blanks if that is what you want. Something like =COUNTIFS(A2:A100,"<>",B2:B100,"") or whatever range you are looking at.

[XLent]

good rule of thumb, for text, is to use ?* as your criteria -- the use of ? will ensure null strings are ignored.