Sumif from two differnt columns

**joshgumby87** · 03-01-2013, 02:18 AM

Is it possible to sumif for two different columns? Not sure if this makes sense.

**:) Sixthsense :)** · 03-01-2013, 02:23 AM

Yes.. but describe your requirement with range/column references in detail to suggest something...

**joshgumby87** · 03-01-2013, 02:38 AM

Title Season Language Amount

Star 2 English 50
Egg 3 Spanish 45

Need to break it out by language for each title's amount.

**:) Sixthsense :)** · 03-01-2013, 02:46 AM

Sorry this is not the way which I have requested, I am unable to proceed with the provided details. Attach a sample workbook with expected output.

**Kevin UK** · 03-01-2013, 09:40 AM

Hi joshgumby87

Use the SUMIFS, for example. Assuming your data is in columns A:D

Formula:

Please Login or Register  to view this content.

See the link below.

SUMIFS

Re: Sumif from two differnt columns