I think the problem with your original formula....

  Simsy 13:27 13 Aug 2003

is that you have a "A" instead of a "B" near the end...

=SUMIF($A$2:$A$599,A601,$A$2:$B$599)

should be, I think,

=SUMIF($A$2:$A$599,A601,$B$2:$B$599)

which is what VoG has put..... You've just made a typing error I suspect.

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei Mate 20 Pro review: In-depth hands-on

Project Gemini is Adobe's Procreate rival – a new drawing and painting app for the iPad

iPhone XR release date, price & specs

OnePlus 6T : date de sortie, prix et autres rumeurs