Excel 2003
Is it possible to enter in a single cell a formula which will automatically sum all the values in the columns adjacent to those cells containing a specific word?
Hopefully the attached will illustrate what I wish to do. (Please scroll across to 'April' in the sheet for further info)