Excel & sumif with mutiple criteria

  GlasgowMary 11:29 16 Sep 05
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 05

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac