Quote Originally Posted by jeffreybrown View Post
Hi Linda,

Ok, with your further explanation, if I understand correct, in row 1 you have a header which differentiates what columns should be added together.

=COUNTIFS(A1:G1,"Summary1",A2:G2,"Y")
=COUNTIFS(A1:G1,"Summary2",A2:G2,"Y")
=COUNTIFS(A1:G1,"Volunteer",A2:G2,"Y")

You can even place Summary and Volunteer, the key words in a cell and read off of that cell...

J2 = Summary1
J3 = Summary2
J3 = Volunteer

Now in K2 copied down...

=COUNTIFS($A$1:$G$1,J2,$A$2:$G$2,"Y")

Does this help?
Jeffrey, Thank you for your reply. I think Azumi found the formula I needed. I appreciate your input!