CALCULATE TOTAL EXPENSES USING EXCEL FORMULAE

[thakur]

Hi,

In the given expenses table data. How do I calculate expenses for all the months using excel formulae. Attaching the excel file with expenses table.

Thanks and Regards,
Thakur

 

[Haseeb A]

Hello Thakur,

There are several ways to do it. Here is some,

=SUM(INDEX($D9:$O13,0,MATCH(D17,$D8:$O8,0)))

=SUM(OFFSET($D9:$D13,,MATCH(D17,$D8:$O8,0)-1))

If there is already "Total" row, then you can use VLOOKUP & HLOOKUP

VLOOKUP: Lookup "Total" row & MATCH month column,

=VLOOKUP("Total",$C8:$O14,MATCH(D17,$C8:$O8,0),0)

HLOOKUP: Lookup Month & MATCH "Total" row,

=HLOOKUP(D17,$D8:$O14,MATCH("Total",$C8:$C14,0),0)

 

[Somendra Misra]

Hi Thakur,

Another alternative: In D18 and copy across

=SUMPRODUCT($D$9:$O$13*(D$17=$D$8:$O$8))

Regards,