Hello and erm help!

[MikeyMoo]

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

 

[Michael M]

Hi Mike
I'm having trouble reading it, but try

=SUMIF(A17:A23,"OK",D17:D23)

 

[Snakehips]

MikeyMoo,

Welcome to MrExcel.

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

Hope that helps.

 

[Robert Mika]

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"