not managed to produce anything with that one.

What I need is something like

IF B3:B100 "Jan" and G3:G100 "Clarity" total F3:f100


"Chris Harman" wrote:

Is it possible to have 2 criteria's within sum if function

i.e. I wish to pickup A calendar month and a particular fault description.

Thanks,