syntax in sumifs
Susan: I used the wizard and this is what my formula looked like:
"=SUMIFS($C$6:$C$13,$A$6:$A$13,D$1)". (the quotation marks are not part of the formula as it appears in the cell.)
I made the ranges absolute so I could enter all the days, sum the totals and enter a cross-foot sum funtion of all days to check the total against the total of sales detail by-person-by-day.
What I don't get is the syntax of your formula. I copied it all into excel and can see that it works. I just don't understand this portion: "="&B1. I wasn't able to set up new conditions myself using that syntax. So if I want to use your form and data I am good to go. If I want to use this in another context, I am sunk.
Anywhere you can point me to get a good explanation of this apparent portion of your formula?
