sum product.. multiple arrays?

November 5, 2010 at 09:41:22
Specs: Windows XP
=SUMPRODUCT(--('November schedule'!D2:D75="celadon"),--('November schedule'!G2:G75="on time")) this is what I have now and its working fine, but i want to count the blank cells in G column as on time also. So do I add on to the current formula like this...+('November schedule'!G2:G75="") I want to count the blank cells and the on time cells for just celadon which is selected in column D.. How do I create this forumla.. when I use the 1st function with just "on time" the result is 6. which is correct. but when I add the ="", I only get 7, but I should really get 8.

See More: sum product.. multiple arrays?

Report •

November 5, 2010 at 11:57:18
How about:

=SUM(SUMPRODUCT(--('November schedule'!D2:D75="celadon"),--('November schedule'!G2:G75="on time")),SUMPRODUCT(--('November schedule'!D2:D75="celadon"),--('November schedule'!G2:G75="")))

Report •

November 5, 2010 at 12:27:09
PERFECT.. Thank you !!!

Report •

Related Solutions

Ask Question