Excel Formula

[Foxtrot]

Hi, i have a spreadsheet with 4 columns with headings and many lines. Each line per column contains either a Y or a N, ie Col1-N, Col2-Y, Col3-Y, Col4-N. I'm trying to determine (total) across all 4 columns how many lines contains ALL-Y and/or Col1&2-Y or Col2,3-Y or All Columns = N, etc. The 4 columns are products we sell to our clients and i basically want to work out how many clients use 1 or 2 or 3 or 4 of our products or only 1 of our products or 2 of our products, etc. I basically wants to see it across 4 columns? I dont know how to attach a copy of the data to make it easier? Any help will be appreciated. Thanks

 

[WaterGypsy]

Try: =COUNTIFS(A2:D2,"Y")

Assuming your data is in columns A to D and starts in row 2 .... then copy down