Count based on multiple different criterias

**sika11** · 12-15-2010, 04:44 AM

Hi all,

I have a table with Goal (A) and the Actuals (B)
Now I want to check how many Actuals are above the Goal.
The difficulty is tha every Goal is different.
All functions I found, there needs to be a defind std criteria for the whole range, but I want to use different criterias for each Row!?

Thanks for your help!

**TMShucks** · 12-15-2010, 04:56 AM

Please post a sample workbook with some typical data and an explanation of the crtiteria used for each row.

Regards

**sika11** · 12-15-2010, 05:04 AM

Goal Act
part1 2 3
part2 2 1
part3 1 1.5
part4 1.5 2
part5 3 2
part6 2 1

I just want to see that out of those 6 parts 3 parts have a Act > Goal. This should be done with one forumlar at the top or bottom of the table.

Thanks