Aggregate Countif question

[mhroberts]

This question is cross posted at http://www.mrexcel.com/forum/showthr...=1#post2507661.

So I've searched probably about two hours for a solution but can't find one.

I'm trying to get a cell ('Results'!$G$3) to look at the row of a table on the a raw data tab ('Raw Data'!$A$2:$U$2), with a header row of ('Raw Data'$A$1:$U:$1) and check it against the list of names ('Results'!$B$22:$B$31). Then, if the name is in the list AND the header from the raw data, and the answer on that row is a Yes, then tell me what the total count of those yeses is.

Can you please help? Thanks!

By the way, this is what my mess of a code looks like right now.

=COUNTIFS('Raw Data'!B1:U1,Results!B22,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Result+s!B23,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B24,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B25,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B26,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B27,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B28,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B29,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B30,'Raw Data'!B2:U2,"YES")+COUNTIFS('Raw Data'!B1:U1,Results!B31,'Raw Data'!B2:U2,"YES")

[BlastRanger]

Hi,
I can see that the 'Results'!$G$3 would be the same with those result in Column C

The formula of column C :
=COUNTIF('Raw Data'!B2:U2,"YES")

That will count those YES,

AND
of course it's the same with the criteria you want with the 'Results'!$G$3

if the name is in the list AND the header from the raw data, and the answer on that row is a Yes, then tell me what the total count of those yeses is.

Logically your purpose still want to count those YES

Or maybe you want to get something different?

[DonkeyOte]

In your sample you had:

Please Login or Register  to view this content.

all you need do is encase the above within a SUMPRODUCT to aggregate based on the B22:B31 criteria

Please Login or Register  to view this content.

the above will give you the breakdown by question of the 109 YES'

(on an aside please try to keep titles as specific as possible - I modified the title slightly on this occasion)