Counting people
 

Hi,

I've got a spreadsheet which has one column with names, another the
number of people and the third confirmed attendance i.e.

Jack & Jill 2 N
Simon & Jane 2 Y
Peter 1 Y

My question is how can i get excel to look at the confirmation column
and for every confirmation to add the number of people to a confirmed
total?

Many thanks

Ben

Counting people
 

skrev i en meddelelse
oups.com...
Hi,

I've got a spreadsheet which has one column with names, another the
number of people and the third confirmed attendance i.e.

Jack & Jill 2 N
Simon & Jane 2 Y
Peter 1 Y

My question is how can i get excel to look at the confirmation column
and for every confirmation to add the number of people to a confirmed
total?

Many thanks

Ben


Hi Ben

One way:

=SUMPRODUCT((C2:C200="Y")*B2:B200)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

Counting people
 

Consider setting up a PivotTable for the report.

--
Cheers
Nigel



wrote in message
oups.com...
Hi,

I've got a spreadsheet which has one column with names, another the
number of people and the third confirmed attendance i.e.

Jack & Jill 2 N
Simon & Jane 2 Y
Peter 1 Y

My question is how can i get excel to look at the confirmation column
and for every confirmation to add the number of people to a confirmed
total?

Many thanks

Ben

Counting people
 

Thanks will look into these

Counting people
 

skrev i en meddelelse
oups.com...
Thanks will look into these

You're welcome.

LeoH