Name Ranges

Hi Tanya

Thank you for your question

You first need to create names for the criteria range and the sum range. To do this select each range in turn and then click in the name box(Located on the toolbar on the extreme left), type in the range name (no spaces allowed) and press enter.

You can then use these names in the sumif function. For example if your criteria range is named "Criteria" and your sum Range is called "SumR" and you want to add up everything where the criteria range contains "Bill".


=sumif(criteria,"Bill",sumr)

Would do the trick


Hope this helps

Regards

Stephen