if function help
in [Functions]
|
Prev: How do I delete a calendar function from a spreadsheet
Next: How can I merge unprotected cells in a protected worksheet?
From: Ashish Mathur on 28 Apr 2010 19:58 You are welcome -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "kathy" <kathy(a)discussions.microsoft.com> wrote in message news:0AFE4AD5-D604-448E-8088-050751BEBDC5(a)microsoft.com... > Thank you that works, now how do I change this to count if with the same > information. I tried changing sumif to countif, but the answer was not > correct. > -- > Thank you, Kathy > > > "Ashish Mathur" wrote: > >> Hi, >> >> Try this >> >> =sumif(B4:B14,">=151",E4:E14)-sumif(B4:B14,">366",E4:E14) >> >> -- >> Regards, >> >> Ashish Mathur >> Microsoft Excel MVP >> www.ashishmathur.com >> >> "kathy" <kathy(a)discussions.microsoft.com> wrote in message >> news:A9F1BC40-F9DD-42F5-96BD-3618D128F723(a)microsoft.com... >> > i am trying to create an if function that will sum data in a column if >> > the >> > cell value is between certain values. >> > This works for sum if greater than, =ifsum(b:4:b14,"<366",e4:E14) >> > When I try to have the sum of E4:e14 if b4:b14 is between 151 and 366 I >> > am >> > unable to get the criteria written correctly. HELP! >> > -- >> > Thank you, Kathy >> |