Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 20th 05, 06:28 PM posted to microsoft.public.excel.worksheet.functions
Bobito
 
Posts: n/a
Default How to nest functions with SUMIF function in excel

I am trying to use 2 variables with the SUMIF function. ie:-
sumif(<range1,<criteria1)(<range2,<criteria2), <sum_range
So far, I cannot find out if this is possible. Has anyone tried and managed
to do this successfully?

I thought maybe that the AND function has to be used ... for example:-
Sumif(AND(A:A,"Car"(B:B,"Red",C:C))) - but with this example, I get the
error message:- "You've entered too few arguments etc "

  #2   Report Post  
Old November 20th 05, 06:31 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How to nest functions with SUMIF function in excel

=SUMPRODUCT(--(A1:A200="Car"),--(B1:B200="Red"),C1:C200)

note that you cannot use the whole column (no A:A or B:B)

--
Regards,

Peo Sjoblom

(No private emails please)


"Bobito" wrote in message
...
I am trying to use 2 variables with the SUMIF function. ie:-
sumif(<range1,<criteria1)(<range2,<criteria2), <sum_range
So far, I cannot find out if this is possible. Has anyone tried and
managed
to do this successfully?

I thought maybe that the AND function has to be used ... for example:-
Sumif(AND(A:A,"Car"(B:B,"Red",C:C))) - but with this example, I get the
error message:- "You've entered too few arguments etc "


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
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Why not nest more than 7 functions in Excel formula??? GrandCentral Excel Worksheet Functions 9 March 31st 05 09:30 PM
Can you nest a MID function within a IF function in Excel Dawn-Anne Excel Worksheet Functions 2 March 4th 05 01:37 PM
How can I nest more than seven functions in MS Excel? DMB Excel Worksheet Functions 3 January 9th 05 04:47 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017