# Hello and erm help!

#### MikeyMoo

##### New Member
Hello all!

Ok here is my problem. I hope it is simple to solve (and apologies if it is!)

Below is my data (you'll have to "CTRL + +" to get a good view):

http://i4.photobucket.com/albums/y142/BizUnoTurbo/Capture_zpsfd9def85.jpg

I want to add the number of rows in the Cos(Phi(i)) or Sin(Phi(i)) relative to the number of rows in column A that are green.

This is vehicle engine balancing, the data I want to sum is based on the number of cylinders the engine has as this changes.

Sorry the image is not clear! (Snipping tool!)

Cheers
MikeMoo

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).
Hi Mike
I'm having trouble reading it, but try
Code:
``=SUMIF(A17:A23,"OK",D17:D23)``

MikeyMoo,

Welcome to MrExcel.

To sum Cos Try =SUMIF(A17:A23,"OK",D17:D23)

Hope that helps.

Hello all!

Ok here is my problem. I hope it is simple to solve (and apologies if it is!)

Below is my data (you'll have to "CTRL + +" to get a good view):

http://i4.photobucket.com/albums/y142/BizUnoTurbo/Capture_zpsfd9def85.jpg

I want to add the number of rows in the Cos(Phi(i)) or Sin(Phi(i)) relative to the number of rows in column A that are green.

This is vehicle engine balancing, the data I want to sum is based on the number of cylinders the engine has as this changes.

Sorry the image is not clear! (Snipping tool!)

Cheers
MikeMoo

Could you state your desired outocome?
Do we count by green cells or by "OK"

Replies
12
Views
428
Replies
15
Views
776
Replies
10
Views
760
Replies
19
Views
1K
Replies
1
Views
895

1,196,462
Messages
6,015,390
Members
441,890
Latest member
Liero131313

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back