conditional (if and and)

  • Thread starter Thread starter thanks for the help mate
  • Start date Start date
T

thanks for the help mate

this is the formula I am using at the moment, but need it changed to allow
extra conditions.

=SUMIF(LOGS!B:B,A3,LOGS!D:D)
B is the column with the names in it, where people have done photocopies.
A3 is the column that has the name that is used to work out how many copies
were done.
A4 line would have another persons name in it and so on
D is the column with the number of copies done on that run.

I need it to only add if another column has the word 'ok' in it. lets say
column E would have the status of whether the job completed or not.

so if the field had 'scan' of 'cancelled' or anything else otherthan 'ok'
then it would not add that figure to the final total.

if you need the excel sheet sent please ask.

thank you in advance for you help.

J
 
try using sumproduct. Ranges must be the same size
=sumproduct((b2:b200=a3)*(c2:c200="OK")) to count

=sumproduct((b2:b200=a3)*(c2:c200="OK")*d2:d200)to sum d for conditions b &
c
 
Try...

=SUMPRODUCT(--(LOGS!$B$1:$B$100=A3),--(LOGS!$E$1:$E$100="ok"),LOGS!$D$1:$
D$100)

Adjust the range accordingly.

Hope this helps!
 
Back
Top