if function for free kick times

[molemeister]

i want to produce a bar chart to show the times when free kicks happened in a soccer match. the free kicks happen at different times during a game so i want to separate them into the following groups. i already have the free kick times listed, over 800 free kicks
can someone help me create an if function for this??


1st half
0-15mins
15-30mins
30-50 mins (50 because of added on time)

2nd half
45-60
60-75
75-95

[teylyn]

You're probably looking at either a Pivot table/chart or some kind of Sumif/Sumproduct, but to best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[molemeister]

i have added an excel file to another message which is the same as this. do you think you could check it out???

[teylyn]

no need to create another thread, in fact not a good idea at all. Please continue in this thread.

[teylyn]

The attached file has a pivot table and chart based on your data.