Counting total for multiple criteria

A

aass11

Hi all,

I have a simple table with two columns:
-What was agreed (2 digit code eg. FV, PC, PE...)
-Was it acheived (Y/N)

This is a daily log over a 5 day week, therefore there are 5 rows in
the table (Monday to Friday).

I need to create a summary table for each two digit code (FV, PC....)
where the fomula counts only if the task was acheived.

I have managed to use COUNTIF to create a table listing the codes and
how many instances they occur, but how do I now only count the
instances if the next cell states "Y" for acheived?

Thanks.
 
E

Excelenator

Say your codes are in Cells A1:A25 and the results are in B1:B25 you can
use SumProduct to count the successess and failures. The formula is

Sumproduct(($A$1:$A$25="PE")*($B$1:$B$25="Y"))

Copy the formula and change the codes and results (Y/N) to get any
combination you want.
 
A

aass11

Excelenator said:
Say your codes are in Cells A1:A25 and the results are in B1:B25 you can
use SumProduct to count the successess and failures. The formula is

Sumproduct(($A$1:$A$25="PE")*($B$1:$B$25="Y"))

Copy the formula and change the codes and results (Y/N) to get any
combination you want.
Click to expand...

Super answer in super quick time!

Many thanks
Al
 
Top