Excel & sumif with mutiple criteria

  GlasgowMary 11:29 16 Sep 05

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.

  GlasgowMary 12:04 16 Sep 05


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


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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac