PDA

View Full Version : Solved: Sumproduct (Formula not working correctly)



Hoopsah
05-20-2008, 03:20 AM
Hi,

I have attached a sheet to show what I am trying to do here and I have left in any formulas that I am currently using.

There are 2 sheets "Process 2" and sheet 3

Within sheet 3 there is a list of dates in column B
Columns C, D & E should do the following

If it is greater than the first date in column B but less than the date in the next cell then count all the appropriate cells in Process 2.

Firstly, the SUMPRODUCT that I am using is not working correctly and secondly, I would ideally like it to only count the ones that are a process 2

Hope this makes sense :banghead:

xld
05-20-2008, 03:57 AM
C7: =SUMPRODUCT(--('Process 2'!$B$2:$B$170>=B7),--('Process 2'!$B$2:$B$170<B8),--('Process 2'!$E$2:$E$170=C$6))

Hoopsah
05-20-2008, 04:05 AM
Once Again !!!

XLD - it always looks that straighforward once it is done.

Cheers again for your help - this formula works absolutely perfectly.

:thumb