Posted to microsoft.public.excel.worksheet.functions

tgavin

external usenet poster

Posts: 2

Sumifs, averageifs, countifs

I am an excel trainer and I am trying to prep the new functions and I can't
get the ifs to work. If I use the functions for 1 criteria, it works, when I
add the 2nd, I get 0 for sumifs and countifs and #div/0! for averageifs.

=SUMIFS(E6:E23,D6:D23,"Sales") returns 166,000

=SUMIFS(E6:E23,D6:D23,"Sales",D6:D23,"Production") returns 0

I am following the tool tips, what am I doing wrong?

Terri

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIFS or COUNTIFS help !	Joe S[_2_]	Excel Worksheet Functions	5	March 22nd 09 12:44 AM
Sumifs and Countifs	Costas Limassol[_2_]	Excel Worksheet Functions	3	March 2nd 09 12:01 AM
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr	Steve	Excel Worksheet Functions	2	January 4th 09 05:36 PM
Excel CountIfs() and SumIfs() question	Harlan Grove	Excel Worksheet Functions	1	September 18th 07 12:12 AM
Averageifs & Countifs	Stephanie	Excel Worksheet Functions	3	June 13th 07 12:15 PM

All times are GMT +1. The time now is 05:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us