IFSUM issues

**wonderboy953** · 07-04-2011, 01:40 AM

Hi There im having a problem trying to calculate a "ifsum" which contains a data validate category. can some one help me

=_xlfn.SUMIFS(E11:E38,"Books",G11:G38)

see file attached

**NBVC** · 07-04-2011, 07:45 AM

What version of Excel are you trying to apply this to?

The formula is supposed to look for the word Books in E11:E38 according to your formula, yet there is no such item in column E? What really is the formula supposed to do for you?

**wonderboy953** · 07-04-2011, 10:29 PM

Originally Posted by NBVC

What version of Excel are you trying to apply this to?

The formula is supposed to look for the word Books in E11:E38 according to your formula, yet there is no such item in column E? What really is the formula supposed to do for you?

if you look at the adjacent column there is a drop down which you can choose from categories, when i choose the categories of Books it dosn't do any thing

thanks for your response

**wonderboy953** · 07-04-2011, 10:30 PM

Originally Posted by wonderboy953

if you look at the adjacent column there is a drop down which you can choose from categories, when i choose the categories of Books it dosn't do any thing

thanks for your response

im using excel 2003

**NBVC** · 07-05-2011, 09:48 AM

SUMIFS doesn't work in XL 2003... it is new as of XL2007.

You need SUMIF... but the arguments will have to be re-arranged. Also, the data range seems to start at row 10, not row 11.

So try, for example in I8: =SUMIF(G10:G38,"Books",E10:E38)

adjust other formulas similarly.