Thread: Calculating the average value with criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Calculating the average value with criteria
Hi Kaj,

Am Sat, 26 Dec 2015 21:31:03 GMT schrieb :

B1=2
B2 (empty)
B3=4
B4=7 (A4 contains the text "She is a nice girl". Therefore cell B4 shall not
be included in the average.
B5=9
______

In this case the calculated value in cell B6=5 ((2+4+9)/3)

you can do it with formula:

=AVERAGEIFS(B1:B5,A1:A5,"<"&"*girl*",A1:A5,"<"&" *boy*",A1:A5,"<"&"*lady*")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote