If sumif for multiple criteria

[anwitha]

Hi,

In summar table, Need to get the total amount details datewise for each countries if sponsor is 111,222,333 as per the data table.

[:) Sixthsense :)]

In D3 Cell


=SUM(SUMIFS($O$3:$O$8,$N$3:$N$8,$C3,$M$3:$M$8,D$2,$P$3:$P$8,{111,222,333}))


Drag it down and right

[anwitha]

thanks a lot