Here is the table for our results. I have placed the names of companies I’m interested in, in column A and sales people in row 2. The SUMIFS function will be in the boxed area B3:H8. In cell B3 place ...

I keep running into situations in Excel where I want to calculate a conditional sum, but my criterion is something along the lines of "Include cell B1 if cell A1 is a number, likewise B2 and A2 ...

From the Not Just Numbers blog: Before getting into today’s post I want to point you to an excellent free Webinar being offered (for a limited time) by Mynda Treacy, entitled “Creating Excel ...