Counting One Range with Conditions in Another Range

[gsandy]

I have random "X"s in a column of cells in a range called "Won". I wish to count these if the adjacent cell in another range called "Valu" is greater than a value determined in the cell E3. The result to be entered in Cell G4. Can use Excel formulas or VBA.

Thanks Sandy

[NBVC]

Something like

=Sumproduct(--(Won="X"),--(Valu>E3))

[shua79]

how about something like this formula

Please Login or Register  to view this content.

Hope this helps some.

[shua79]

Sorry NBVC, there wasn't a reply when I started.

[gsandy]

Thanks for all the help, works great. I was working on a vba solution, your way was a lot better.
Thanks again Sandy