Worksheet calculation formula

**mal.b.graham** · 05-03-2012, 04:56 AM

I have a large training record spreadsheet and now the higher management require a certain type of analysis report which I am trying to compile....

So far I have been able to use the formula COUNTIF(Data!$E$2:$E$1611,"="&A3) and this gives me the total number trained against various courses (listed in A3:A10)

However I am now trying to ammend this calculation so that I can now break this down further by initial or refresher training and this is located in column L on the data sheet.

Any help appreciated on this matter

Mal

**Fotis1991** · 05-03-2012, 05:01 AM

Hi

Looks to me that you need COUNTIFS, or SUMPRODUCT function.

Would you upload a small workbook for us?

**mal.b.graham** · 05-03-2012, 05:22 AM

Sample work book attached..... i have put in dummy records but my file does have 1600 rows of information.

I am trying to show how made trained by group, by department, by initial and refresher

Any guidance / assistance appreciated

Mal

**zbor** · 05-03-2012, 05:27 AM

I think it's easiest to use SUBTOTAL function. Then you can filter what do you want (group, trainer, both, anything else) and you'll always get desired number.