Formula to count in Excel? 1

[Asspin]

Ok so I am working on a spreadsheet that has a series of data broken up by quarter. I used this formula to sort it, there are 4 columns similar to this:

=IF($F2<>"",CHOOSE(MATCH(MONTH($F2),{1,4,7,10}),$B2,"","",""),"")

There is also another 4 columns sorting another set of data in the same way. So now what I have is a need to count the number of times the value "Green" is in one of the columns and the value "Complete" is in a second column.

I am not entirely sure how to go about this, any help would be appreciated. I know I could do it via some VBA, but we are needing a formula.

Dan

 

[SkipVought]

Hi,

I used this formula to sort it, there are 4 columns similar to this:

You are not SORTING anything with a formula.

Check out the SUMPRODUCT function...
[tt]
=SUMPRODUCT(--(one of the columns="Green")*(a second column="Compete"))
[/tt]


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Asspin]

Sweet, I got what I needed! Thanks!

Dan