Match

  • Thread starter Thread starter Zhead
  • Start date Start date
Z

Zhead

In coloumn A some cells contain "Y" coloumn F also has cells that contain a
"Y" i would like to know how to sum which same rows in A and F contain "Y"
 
smartin said:
Try:
=SUMPRODUCT(--(A:A="Y"),--(F:F="Y"))
Click to expand...

I don't believe SUMPRODUCT permits column references like that, as least not
in Excel 2003.

i would like to know how to sum which same rows in A and F contain "Y"
Click to expand...

If by "sum", you mean "count", then try:

=SUMPRODUCT((A1:A100="y")*(F1:F100="y"))

But if you mean that you would like to sum another range (X1:X100)
corresponding to those conditions, try:

=SUMPRODUCT((A1:A100="y")*(F1:F100="y"),X1:X100)
 
Thanks for the information.
I am using this formula and it does what I need.
=IF(--(A:A="Y"),(--(F:F="Y")))
 
Back
Top