Help with formula

R

Richard

=IF(B3="","",MAX(B3-SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B),))
Is there any way to change this formula to when there is a date next to it
(columnD) it will only count those date that are the same, and so on.
Example: All dates that are the same do calculation for that date
 
P

Pete_UK

SUMIF can only use one criteria, so you will need to replace this part
of your formula with SUMPRODUCT, along the lines of:

SUMPRODUCT(('Sent to Assembly'!A1:A1000=A3)*('Sent to Assembly'!
D1:D1000=D3)*('Sent to Assembly'!B1:B1000))

I've assumed dates are in column D on both worksheets. I've also
assumed you have up to 1000 rows, as you can't use full column
references in SP (prior to XL2007). Change the cell references to
suit.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top