Excel 2007 : Help with sums?

**ruapilot** · 09-24-2009, 01:10 PM

Hi, i am very new at using excell and have a question. I am trying to do a pilot logbook up and am having trouble with taking info from select cells that contain the word C152and getting it to total the numbers up in other cells. The word C152 would be in column D rows 22 to 1000. I need it to post the numbers from columns K thru P rows 22 to 1000 whenever the word C152 is used. I need it add the numbers in column A row 16. i have been able to get it to work with the formula

=sumif(D22:D1000,"C152",K22:K1000)

As soon as i try to add columns l,m,n,o,and p i have errors. Any suggestions?

As well i would like to set up a box that tallies all my numbers in the last year.

Thanks

**shg** · 09-24-2009, 01:15 PM

Try this: =SUMPRODUCT( (D22:D1000="C152") * K22:P1000)

**ruapilot** · 09-24-2009, 01:22 PM

Thanks, worked perfectly!

**shg** · 09-24-2009, 01:24 PM

You're welcome. Please take a few minutes to read the forum rules about thread titles for your next post, and then mark the thread as Solved, if you would.