Fetch Sales data with ID and Month

Hi,
I have a sales data in A:C Range which contains ID, Sales Value and month.

I need the Sales Data month wise summary using ID.

Attaching the sample file for your reference.

Thanks
Webmax

Use this formula in G2:

=SUMIFS($B$3:$B$13,$A$3:$A$13,$F2,$C$3:$C$13,G$1)

then copy across and down to fill your table.

Hope this helps.

Pete

G2=SUMIFS($B$3:$B$100,$A$3:$A$100,$F2,$C$3:$C$100,G$1)

Copy across and down

Hi,

try:
=SUMIFS($B$3:$B$13,$A$3:$A$13,$F2,$C$3:$C$13,G$1)