Excel & sumif with mutiple criteria

  GlasgowMary 11:29 16 Sep 2005
Locked

I have 3 columns A has dates spanning 1 year; B has types of visitor (schools\community etc); C has numbers of visitors.
I would like to sum the number of visitors each month by type of visitor.

Thanks in anticipation.
Mary

  GlasgowMary 12:04 16 Sep 2005

Hi,

Have just modified the SumProduct function you gave me yesterday. Works a treat.

Thanks,
Mary

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires