All articles with 'sumproduct' Tag

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]

Published on Jan 6, 2010 { 8 Comments }
Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
Continue »

Christmas Gift List – Set your budget and track gifts using Excel

Published on Dec 7, 2009 { 10 Comments }
Christmas Gift List – Set your budget and track gifts using Excel
Continue »

What is Excel SUMPRODUCT formula and how to use it?

Published on Nov 10, 2009 { 32 Comments }
What is Excel SUMPRODUCT formula and how to use it?
Continue »

Product Recommendation – Excel Lookup Toolbox

Published on Nov 5, 2009 { 3 Comments }
Product Recommendation – Excel Lookup Toolbox
Continue »

Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]

Published on Oct 6, 2009 { 13 Comments }
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]
Continue »

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Published on Aug 24, 2009 { 7 Comments }
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Continue »

Count the number of unique values in a range [Quick Tip]

Published on Aug 6, 2009 { 14 Comments }
Count the number of unique values in a range [Quick Tip]
Continue »

Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]

Published on Aug 5, 2009 { 13 Comments }
Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]
Continue »