IF( and COUNTIF( Problems

[TJHARJ]

I am working to create a tool that uses a dump sheet, and sheet that will be populated once the dump sheet is filled.

I have 4 main catagories that i have used COUNTIF( to sort. Within each catagory there are 4 sub catagories.

I have tried to do =if(Trade,"A")=countif(Catagory,"B"),"0")

and I am getting to results.

What I need is the count of"B" if "A" is met.

After that I will need to break those two catagories down again similar to what I did with A to B.

I am using microsoft excel 07.

Please respond if you have an idea of what I am doing wrong or another method for obtaining this information.

Thanks

 

[TJHARJ]

I figured I wouldn't bother posting another thread, I am doing a countifs, and a sumifs and I want one of the critira to be if the cell is blank.

I have tried using <>, ><, null, isnull, and none of them seem to be working.

Any ideas?

 

[Jonmo1]

Try

=""

 

[TJHARJ]

Thanks, that worked.

does "" work with certain equations vs. null, isnull working with others? or will "" always return blanks in excel 07?