Hello

I need to calculate the total value for all cells horizontally which have a particular value.

For example, across row b I have the days of the week replicated 18 times (Sunday to Saturday) and below in row c a total value. I want to calculate the total value for all Sundays into a particular field.

Can anyone help?

Many thanks

Novice Rich