Re: $$Excel-Macros$$ sum values with col/row criteria

2015-01-18 Thread Vaibhav Joshi
hi can you share an excel sheet with example with little more explanation on how you arrived to result.. Cheers!! On Sat, Jan 17, 2015 at 3:09 PM, MLT wrote: > Here's one: > > In A1:A7: > 1st > 3rd > 1st > 2nd > 3rd > > In B1:E1: 3, 2, 5, 4 > > In C4: cat > In E7: dog > > I want to make a form

$$Excel-Macros$$ sum values with col/row criteria

2015-01-17 Thread MLT
Here's one: In A1:A7: 1st 3rd 1st 2nd 3rd In B1:E1: 3, 2, 5, 4 In C4: cat In E7: dog I want to make a formula that will count the number of cells in a range that contain a string (any string), but that also falls under row and column criteria. For example, if the column criteria is "3rd" and