Excel formula
 

I want to get a total of range b3:af3 for cells that has s= a number ex 2,5,3
and have a formula to give me totals for those entries?

Excel formula
 

??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick" wrote in message
...
I want to get a total of range b3:af3 for cells that has s= a number ex
2,5,3
and have a formula to give me totals for those entries?

Excel formula
 

Check your earlier post.

Rick wrote:

I want to get a total of range b3:af3 for cells that has s= a number ex 2,5,3
and have a formula to give me totals for those entries?

--

Dave Peterson