I am trying to work out how to count a row of cells with

We use cookies to improve your experience. By continuing to use this site you consent to the use of cookies as described in our cookie policy, unless you have disabled them.

Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Go back-and-forth until satisfied

Rate the answer you receive.

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them.

Ask Bing Your Own Question

Bing, Programming Tutor

Category: Programming

Satisfied Customers: 7514

Experience: Microsoft Certified Solution Developer

96068672

Type Your Programming Question Here...

Bing is online now

I am trying to work out how to count a row of cells with

Customer Question

Hi i am trying to work out how to count a row of cells with both negative and positive values JA: Is there a specific language you're coding in? Customer: I'm not coding, just using formulas JA: What's your objective? How can we solve this for you? Customer: I have different values in each cell and i want to count each cell that contains a minus value and also 0 JA: Anything else you want the programmer to know before I connect you? Customer: No

Submitted: 9 days ago.

Category: Programming

Share this conversation

Customer:replied 9 days ago.

Row 1 has -109.87 -109.87 0.00 0.00 0.00 0.00 and i want to put a value in another cell based on these values

Customer:replied 9 days ago.

I'm currently using this formula for the 0.00 but don't know what to add for the negative numbers =IFS(COUNTIF(E1:H1,0)=4,1,COUNTIF(E1:H1,0)=3,2,COUNTIF(E1:H1,0)=2,3,COUNTIF(E1:H1,0)=1,4,COUNTIF(E1:H1,0)=0,5)

It needs to be a string of formulas that will give me for example the value of 1 based on the fact that all cells above are either a negative value or 0 in the order of the cells they appear

Customer:replied 9 days ago.

File attached (744S1T7)

Customer:replied 9 days ago.

Can you show me how the formula will look in its entirety

I am doing this as i don't know of an easier way to do it. So on sheet 2 row 1 i want to be able to look at cells c to h and because they are either 0 or minus in value then count that as 1. In all honesty there maybe a better way. If you look at sheet 1 and i have added a conditional format based on cell values. I would have preferred to have counted by colour on this sheet however because its a conditional format it won't work or so i believe

Customer:replied 9 days ago.

ideally i wanted to count the greens on Sheet 1 and then split between A/C based on my formula on Sheet 2 column O

No thats not what i'm after, i don't want to count the amount of times they appear. i was trying to have a value for each row that had those number of values appearing in the cells. If you look at sheet 1 it has 4 green entries based on the formatting i included based on those cells. I want to be able to automatically count those green rows (i.e 4) but then split them based on the A/C value in column A. So in this case any starting with ZNCL is Newcastle and Lockhart is other or customer. Does this make sense?

Customer:replied 9 days ago.

from those four green rows it splits into 1 customer and 3 Newcastle

Customer:replied 9 days ago.

then the same thing for the other formatted colours

Customer:replied 9 days ago.

Are you still there Bing?

Customer:replied 9 days ago.

Could you let me know your still on with this please as its been over half an hour