Sumif and Index Match

**freqzz** · 08-27-2014, 01:53 AM

Hi,

Im trying to create a summary from a big data. I have tried with vlookup + sum if but since the value is before the lookup, it doest work.

Please Login or Register  to view this content.

How can archive this with sumif and index?

Thanks in advance.

**Punnam** · 08-27-2014, 02:02 AM

Hi,

Check this.

Punnam

**kmahesh** · 08-27-2014, 02:18 AM

See the file attached.

I dont think there is need of Index , only sumifs is giving the desired results.

Kmahesh

**freqzz** · 08-27-2014, 03:32 AM

HI,

Works like a charm!

i'll pin this as solved!

Thank you.

Re: Sumif and Index Match