Select and Sum (Office 97)

Topic

New Reply

Hi All

I would like to be able to sum a column based on the text in the adjacent cell. I have attached a sample worksheet

Thanks in advance

Reply | Quote

Replies

In your example, to sum the first set of numbers use

=SUMIF(C5:D11,”Sales”,D5:D11)

Reply | Quote

Hi Tony

Thank’s very much for your help, I would just like to say to all loungers how refreshing it is in this day and age that there are such fine people as yourselves that are willing to help novices like myself.
Thank’s again
Braddy77

Reply | Quote