Summarize data with multiple conditions

O

OkieViking

I have a dataset with basically 3 columns of data of interest. 2 columns
contain conditions (location and month), and the 3rd column contains a
numerical value (hrs). The worksheet has a header row, and the data starts
right below (no blanks). I want to build an equation to sum the hrs for a
specific month and place. The equation below works as long as I know how many
rows of data I have:

=SUM(IF((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

Unfortunately, Data will be added on a daily basis, so I don't know how many
rows are in the range. If I just select the column it gives me an error
message. Is there a trick that will allow me to accomplish this without
having to modify the equation routinely? Not all the users of the
spreadsheet are Excel savvy.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top