Match & Countif

**Killer17** · 12-08-2010, 12:30 AM

Hello all need help if creating a formula

I think it's a match & Countif I'm looking for...

Thanks

**6StringJazzer** · 12-08-2010, 01:07 AM

The solution to this is trivially easy so I think you must have a more complex layout in mind.

This solution

Please Login or Register  to view this content.

gives you the flexibility of handling any number of columns or rows, and assumes no COUNTIF formulas are there on W12 and W13.

If you don't need that much flexibility then a simpler formula may do the job.

**mahju** · 12-08-2010, 07:30 AM

The simple formula for this is

enter
=SUM(W12!I2+W13!I2)[/CODE]

in C7 of sheet 1 ti get the total for Player 1 and copy it down
Regards

**Killer17** · 12-09-2010, 11:26 PM

My bad I didn’t explain it correctly.

I need the formula to match the names and total up the X’s from each sheets

I have created another example sheet

Thanks