Combining 2 SUMIF Statements (2.3)

Topic

New Reply

I have columns of data with the following attributes:

Column B has key #1, Column F has data to sum, Column G has key #2

I want to add column f if Col#1 and Col#2 contain two values.

I can do two sumif statements to do two things at once for a subtraction, but I can not figure out how to do this. What I want is this:

=(SUMIF(B4:B48,”7.3 fx” & G4:G48, “T”,F4:F48)

This is just adding a second conditional to the sumif function. I know this doe snot work

Is there a way to do this without a ton of work.

Thanks,

Andy

Reply | Quote

Replies

What is version 2.3? Do you mean 2003?

Excel 2007 has a new function SUMIFS that allows you to specify multiple conditions, but SUMIF (available in all versions of Excel) can only handle one condition.

You can use the SUMPRODUCT function instead:

=SUMPRODUCT((B4:B48=”7.3 fx”)*(G3:G48=”T”)*F4:F48)

Reply | Quote

Thanks Hans!

Reply | Quote