Remember Me?

#1
November 20th 05, 07:28 PM posted to microsoft.public.excel.worksheet.functions
 Bobito Posts: n/a
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
November 20th 05, 07:31 PM posted to microsoft.public.excel.worksheet.functions
 Peo Sjoblom Posts: n/a
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

"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 "

#3
January 3rd 17, 08:45 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2017 Posts: 4
How to nest functions with SUMIF function in excel

http://tutorialway.com/use-sumif-function-in-excel/
visit this site

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM GrandCentral Excel Worksheet Functions 9 March 31st 05 09:30 PM Dawn-Anne Excel Worksheet Functions 2 March 4th 05 02:37 PM DMB Excel Worksheet Functions 3 January 9th 05 05:47 PM

All times are GMT +1. The time now is 04:23 AM.