HLOOKUP Help

[GRynners]

Sure this must be quite easy, but I'm trying to sum the number of training
days people have planned, booked or completed. A simplified version of the
sheet looks like this:


DAVE B B P P C C
FRED B C C

DAYS
for 1 2 1 2 3 1.5
course excel word ppoint access etc etc

The values I want are Dave - 3 days Booked, 3 days Planned, 4 days
Completed. Fred 1 day Booked, 3 days Completed.

However, the H lookup only returns a single value (whatever is thie highest
value in the lookup). How can I ensure the days are summed?

Hope this makes sense, as first time on here!

Thanks.

 

[Pete_UK]

Assuming the data for Dave is on row 1, and the course data is on row
10, you could get the number of days booked by Dave using this
formula:

=SUMIF(B1:G1,"B",B$10:G$10)

Similar formulae, with "B" replaced by "P" and "C" can get you the
Planned and Completed values. You could combine them in one formula
like this (eg in A13):

=A1&": Booked "&SUMIF(B1:G1,"B",B$10:G$10)&", Planned "&SUMIF
(B1:G1,"P",B$10:G$10)&", Completed "&SUMIF(B1:G1,"C",B$10:G$10)

Then you could copy this down to produce the summary for Fred (and any
others).

Hope this helps.

Pete