Match and Sumif

**pphg** · 07-21-2014, 05:13 AM

Hi guys

I am comparing two production sheets with line items and need your help to match and sum the numbers depending on the month selected in the dropdown(if selected March, should sum Jan-March). However, each month have two columns (units and revenue), so need to sum each column. Also need to consider that each line item should match from other other sheet because the other have more line items.

Appreciate your help on this, not sure how to go about it. Many Thanks.

Attached Excel file for reference (Excel 2010).

Match&SumIf.xlsx

**samba_ravi** · 07-21-2014, 06:01 AM

see the attached file

**pphg** · 07-21-2014, 06:06 AM

Thank you sooo much! Exactly what I want to achieve! Appreciate it! Cheers!

**:) Sixthsense :)** · 07-21-2014, 06:28 AM

In B7 Cell

=IFERROR(SUMIF(OFFSET('Production 2013'!$G$6,,,,MATCH($A$3,'Production 2013'!$G$5:$AD$5,0)+1),B$6,OFFSET('Production 2013'!$G5,MATCH($A7,'Production 2013'!$A$7:$A$106,0),,,MATCH($A$3,'Production 2013'!$G$5:$AD$5,0)+1)),"")

In D7 Cell

=SUMIF(OFFSET($G$6,,,,MATCH($A$3,$G$5:$AD$5,0)+1),D$6,OFFSET($G7,,,,MATCH($A$3,$G$5:$AD$5,0)+1))

Drag both the formula's down and right....

Match and Sumif

LinkBack

Thread Tools

Rate This Thread

Display

Match and Sumif

Re: Match and Sumif

Re: Match and Sumif

Re: Match and Sumif

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] sumif which finds text, not an exact match, but a close match instead

SUMIF on INDEX/MATCH/MATCH

SUMIF + 1 Row to the match

2010 - Need to match data and return specific cell value - SUMIF? MATCH? INDEX? HELP!

sumif match

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions