This formula is also summing the the value above to give 2 totals.

S

Steved

Hello from Steved

'From Charters'!$F$1:$F$898,{"Contract Kilometres(Manuals)"} the below is
not reading hence it is totalling the cell above, Please what have I not done
correctly.
ie if I delete any part of Contract Kilometres(Manuals) it still calculates
the 2 cells.

=SUMPRODUCT(--ISNUMBER(MATCH('From Charters'!$F$1:$F$898,{"Contract
Kilometres(Manuals)"},0))--('From Charters'!$B$1:$B$898="Period.4"),'From
Charters'!$G$1:$G$898)
Thankyou.
 

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

#VALUE! 8
Combine 2 formulas 3
How can I get this to function please. 2
A 13 period exercise 1
Returning a 0 Value 3
To leave the cell Blank 8
Help with lots of formulas 3
Oracle import 3

Top