allenlikewo

10-11-2004, 09:14 PM

Before I ask I am sorry if this is OT but I don’t really post to any other forums and I know there are people smart enough to help me here

Quick question:

This seems simple but I can’t figure it out. Does anyone here know how to do a multi-conditional COUNTIF statement just using regular Excel functionality (no VBA or anything).

For example: I have a spreadsheet w/ a few columns in the beginning giving possible types of entries they can be (lest say A, B, and C) and I put an x in the cell of the type that it is

Then in the last column I have a cell where there will either be a Y or N (lest say E).

I can easily use a COUNTIF to see how many entries are in column A, B, or C such as: =countif(A1:A25,”x”)

or see how many entries have yes or no in the last column such as:=countif(E1:E24,”N”)

But my problem is what if I only want to see how many Y’s I have in column E if there is an x in column A (or B, or C, etc…)

Can this be done? If so How?

It seems like an easy thing, I have tried lots of combos of different functions to do but I can’t figure it out :banghead:

Thanks in advance for anyone that can help me!

Quick question:

This seems simple but I can’t figure it out. Does anyone here know how to do a multi-conditional COUNTIF statement just using regular Excel functionality (no VBA or anything).

For example: I have a spreadsheet w/ a few columns in the beginning giving possible types of entries they can be (lest say A, B, and C) and I put an x in the cell of the type that it is

Then in the last column I have a cell where there will either be a Y or N (lest say E).

I can easily use a COUNTIF to see how many entries are in column A, B, or C such as: =countif(A1:A25,”x”)

or see how many entries have yes or no in the last column such as:=countif(E1:E24,”N”)

But my problem is what if I only want to see how many Y’s I have in column E if there is an x in column A (or B, or C, etc…)

Can this be done? If so How?

It seems like an easy thing, I have tried lots of combos of different functions to do but I can’t figure it out :banghead:

Thanks in advance for anyone that can help me!