formula needed

S

SuzyQ

I need to show a value in one cell based on a range of cells showing a value
0 but not the sum of those cells. IE I have cells range B4:D155 and F4:G155
Click to expand...
from each of those cells I need to know if it has a value of >0 (I don't care
what the value is)

I need in another cell if(B4>0,1,0) + if(B4>0,1,0) ... + if (D154>0,1,0) +
if (D155>0,1,0) + ...(the second range) How can I accomplish this without
entering all of these as individual cells)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Ignore blank celss in left function 2
Word macro that can call cells out of Excel for a find and replace 0
nested ifs not enough 1
Cumulative formula for word table 0
nested if statements 2
Conditional formatting for time 2
complicated excel formula may need an algebra wiz 1

Top