sumif and left

Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!

Home

FAQ

Profile

Private Messages

sumif and left

Home -> Office -> General Discussions

Next: Unchanging Cell Color

Author

Message

Bonita

External

Since: Oct 25, 2005
Posts: 3

(Msg. 1) Posted: Fri Nov 06, 2009 6:58 am Post subject: sumif and left Archived from groups: microsoft>public>excel>misc (more info?)

col a col b 103 100 204 500 need to sum col b based on the first left character of col a ie 1 100 2 500 -- Bonita

Login to vote

Mike H

External

Since: May 24, 2006
Posts: 3984

(Msg. 2) Posted: Fri Nov 06, 2009 7:10 am Post subject: RE: sumif and left [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hi, This works for your posted data =SUMPRODUCT((INT(A1:A10/100))*(B1:B10)) Mike "Bonita" wrote: > col a col b > 103 100 > 204 500 > > need to sum col b based on the first left character of col a > ie 1 100 > 2 500 > > -- > Bonita

Login to vote

Display posts from previous:

	Home -> Office -> General Discussions	All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Categories:
Windows XP
Windows Vista
Windows Other
Office
Office Other
Security

free stats