Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Nestled SUMIF Functions

Does anyone know if you can nestle multiple SUMIF functions?
--
Izak
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Nestled SUMIF Functions

+
or tell us what you mean because sumproduct may do a better job

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Izak" wrote in message
...
Does anyone know if you can nestle multiple SUMIF functions?
--
Izak


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Nestled SUMIF Functions

If you are wanting multiple criteria, the sensible option is usually
SUMPRODUCT. You'll see countless examples in the archives of these
newsgroups.
--
David Biddulph

"Izak" wrote in message
...
Does anyone know if you can nestle multiple SUMIF functions?
--
Izak



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
sumif functions Macil Excel Worksheet Functions 4 October 17th 08 10:58 AM
Max/min functions similar to SUMIF Monte Milanuk[_2_] Excel Discussion (Misc queries) 3 July 23rd 08 09:57 AM
can you nest sumif functions ? SCarleton Excel Worksheet Functions 2 September 12th 06 11:22 AM
Excel sumif functions? John S via OfficeKB.com Excel Worksheet Functions 1 August 20th 05 01:24 AM
COUNTIF with nestled IF? Scott Calkins via OfficeKB.com Excel Worksheet Functions 2 May 3rd 05 10:25 AM


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"