Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2007

Tip: Looking for answers? Try searching our database.

SumIf function with Multiple cell references

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jgundel - 05 Feb 2007 22:45 GMT
I am trying to have cell in colum A summed IF the corresponding cell in colum
B is the same as a specific cell D4.  Data looks like this.

Data to be summed    If cells here are the same as     The cells here
55                                                    1    0
5                                                     0    1
5                                                     1    2
3                                                    0    3
32                                                    0    4
88                                                     0    5

My forumla looks like this, but it keeps returning Zeros.  
=SUMIF(M$8:M$1051,"=I8",L$8:L$1051)

What am I doing wrong?  Something is wrong with the "=I8" piece.

thanks!
Bob Phillips - 05 Feb 2007 22:53 GMT
Not absolutely sure what you are testing, but maybe

=SUMIF(M$8:M$1051,I8,L$8:L$1051)

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am trying to have cell in colum A summed IF the corresponding cell in
>colum
[quoted text clipped - 14 lines]
>
> thanks!
T. Valko - 05 Feb 2007 22:54 GMT
>My forumla looks like this, but it keeps returning Zeros.
>=SUMIF(M$8:M$1051,"=I8",L$8:L$1051)

Try it without the quotes and the equal sign:

=SUMIF(M$8:M$1051,I8,L$8:L$1051)

Biff

>I am trying to have cell in colum A summed IF the corresponding cell in
>colum
[quoted text clipped - 14 lines]
>
> thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.