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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…