Sumifs

**Treasure_7** · 10-04-2008, 05:47 PM

I am really having problems writing formulas in the SUMIFS argument box even. I need exacts but can't really enter false anywhere in the box.
Any suggestions would be very much appreciated. Thank-you very much!!

Cindy

**Spellbound** · 10-04-2008, 06:40 PM

Hi Cindy

Welcome to the forum.

This link should help you out with more information on SUMIF:

http://www.contextures.com/xlFunctions01.html#SumIf

If you need more help, then attach a sample workbook or post an example.

HTH ...spellbound

**ratcat** · 10-04-2008, 06:45 PM

G'day Cindy and Spellbound,

The sumifs formula is only a xl 2007 function.

For xl 2003 and older version to sumif more than one criteria you need to use the sumproduct formula.

Cheers

**Spellbound** · 10-04-2008, 06:47 PM

Thanks ratcat, that will teach me to read the post more carefully.

spellbound

**ratcat** · 10-04-2008, 07:04 PM

Originally Posted by Spellbound

Thanks ratcat, that will teach me to read the post more carefully.

spellbound

That's not a problem. Its one way it learn

It's good to see that your getting amongst it.

Cheers

**daddylonglegs** · 10-04-2008, 08:57 PM

Originally Posted by Treasure_7

I am really having problems writing formulas in the SUMIFS argument box even. I need exacts but can't really enter false anywhere in the box.

Hello Cindy,

Don't really know what this means, you only use FALSE as an argument in VLOOKUP to indicate an exact match, SUMIFS doesn't work quite the same way.

Perhaps you ought to begin by describing exactly what you want to accomplish. If you're using SUMIFS I assume you want to sum one range based on criteria in one or more ranges, perhaps you can describe what these are?