Date wise column total in another sheet

Dear All

I have a file where 2 worksheet are there
first is income and another is result
In Income sheet First Column is Date another Clien and Then Region
I am inserting so many values for differant region for 1 day

I need output in another sheet as region wise total for specific date

Suppose for todays date 3 entries for A region 5 entries for B region and 7 Entries for C region
Then Result should come in Another sheet Date Column Then, Total of 3 Entries in A Region,
ThenTotal of 5 entries for B region and then Total of 7 Entries for C region

I am not aware with coding
So please attache the sheet So I can understand formula

Please find attached sheet

Please help

See attached for one way of accomplishing this.

Please note you have posted this in the VBA/Macro section of the forum but the solution does not require a macro as it is easily done with formulas. You could also get the same outcome by using a Pivot Table.

BSB.

I tried with this formula but it gives #value error

=SUMIFS(Income!C2:E2,Income!$A:$A,$A2)

Please help

Thanks Dude

It works for me
Just I have to write so long formula when I want to club 10 fields
So If possible try to do something else

Anyway my work is going ahead with this formula

Thanks

Atul