May
I have two columns in excel sheet , A1 to A10 have dates from 1-may-2008 to 10-may-2008 , and B1 to B10 have text (john , matt , hiro ) NOT numbers , basically I would like to see how many johns I have from 3-may-2008 and above , so I did this but don’t know how to compute text in sumif .please help
=sumif(A1:A10, “=>”&C1, B1:B10)
C1: is the date I want to calculate from to the last date i have .
Answer:
i think you are looking for the sumproduct() formula for a case like this
=SUMPRODUCT(( A1:A10>=C1)*(B1:B10=”john”))
sumproduct() is not an array formula. its an MS attempt build useful array formulas into excel…excel 2007 adds sumifs() and countifs() to expand on this idea.
Answer:
just continue the logic
put an end-date in D1
then use this formula
=SUMPRODUCT(( A1:A31>=C1)*(A1:A31<=D1)*( B1:B31="john")) Report It
Answer:
Why can't you just do a simple sort of the data for the column that has the names that you're interested in?
Are you working with huge amounts of data, like everyone's name in the US?
Answer:
you don't sum anything. text labels in spreadsheets have a value of 0. Use DCOUNT. Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList