S
SMAX
Sorry about that. I am new to this and didn't think of the problem
associated with an attachment.
I am really unsure as how to explain what is going on or not going on.
I used the following formula:
=SUMIF(Calls!$A$2:$A$176,A2,Calls!$B$2:$B$176)
Here is the setup:
Sheet One: called "Master List" - This sheet as all of the possibl
types of calls (located in column A with a header and then data fro
A2:A165).
In column B2, I used the fomula above.
Sheet Two: called "Calls" - I have a list of all of the call type
(Header in column A1 & data starts in A2 and goes to A176). In th
next column (B), I have all of the data for each call (header in B1
data starts in B2 and continues to B176)
The odd thing is that the formula works fine until it gets down to hal
way and then does not return the correct data.
I have tried various changes, but still cannot get it to work. I hav
also included small image files showing my work and the formulas alon
with the problem areas.
Again, any help is really (really) appreciated.
Thanks again,
Gu
+-------------------------------------------------------------------
|Filename: Sumif Pics.zip
|Download: http://www.excelforum.com/attachment.php?postid=2685
+-------------------------------------------------------------------
associated with an attachment.
I am really unsure as how to explain what is going on or not going on.
I used the following formula:
=SUMIF(Calls!$A$2:$A$176,A2,Calls!$B$2:$B$176)
Here is the setup:
Sheet One: called "Master List" - This sheet as all of the possibl
types of calls (located in column A with a header and then data fro
A2:A165).
In column B2, I used the fomula above.
Sheet Two: called "Calls" - I have a list of all of the call type
(Header in column A1 & data starts in A2 and goes to A176). In th
next column (B), I have all of the data for each call (header in B1
data starts in B2 and continues to B176)
The odd thing is that the formula works fine until it gets down to hal
way and then does not return the correct data.
I have tried various changes, but still cannot get it to work. I hav
also included small image files showing my work and the formulas alon
with the problem areas.
Again, any help is really (really) appreciated.
Thanks again,
Gu
+-------------------------------------------------------------------
|Filename: Sumif Pics.zip
|Download: http://www.excelforum.com/attachment.php?postid=2685
+-------------------------------------------------------------------