SUMIFS amounts with multiple criteria

**Lucille Boshoff** · 03-31-2014, 06:37 AM

Good day,

I need to calculate amounts with more than one criteria:

I need to calculate the amount (see attached) for Chamisa I with feedback MBS Awaiting auth on a spread sheet of ±7000 entries. I cannot get the SUMIFS function to work, I get a result #VALUE.

Any suggestions please?

Thanks,
Lucille

**zbor** · 03-31-2014, 06:43 AM

I don't see your formula.
But try this:

Formula:

Please Login or Register  to view this content.

**Lucille Boshoff** · 03-31-2014, 07:15 AM

Thanks for your help, your formula worked! I had the same formula but for some reason it did not calculate until I selected the whole column in the formula.

Have a good day!

**zbor** · 03-31-2014, 07:17 AM

Sounds like you didn't use $ signs properly?

**Lucille Boshoff** · 03-31-2014, 07:21 AM

I think that might have been my problem. Thanks again!

SUMIFS amounts with multiple criteria

LinkBack

Thread Tools

Rate This Thread

Display

SUMIFS amounts with multiple criteria

Re: SUMIFS amounts with multiple criteria

Re: SUMIFS amounts with multiple criteria

Re: SUMIFS amounts with multiple criteria

Re: SUMIFS amounts with multiple criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to sum amounts with multiple criteria

SUMPRODUCT / SUMIF on multiple sheets, multiple criteria - and without using SUMIFS?

SUMIFS with 1 criteria range, multiple criteria with cell references

Excel 2007 : Sumifs formula lookup multiple criteria in criteria range

SUMIFS with multiple or/and/not Criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions