LOOKUP FUNCTION As I mentioned, I am writing a new Ebook on Lookup  Functions and am having a blast playing around with some of these for...

CHOOSE FUNCTION I am writing a new CPE EBook on advanced functions and starting with some of the lookup functions. I took a look at the ...

I just picked up a quick way to quickly total a large set of numbers in Excel 2007/2010 and I wanted to share it with you.   With this tip y...

SUMIFS Excel  2007 and Excel /2010 offers some new functions that go beyond the simple SumIf and CountIF as they allow you to test...

AND OR ????? Many people are not familiar with the AND or the     OR   logic  functions. Even people who are familiar with them tend to as...