# Need a sumif formula

December 3, 2012 at 18:28:37
Specs: Windows XP
 I have the following spreadsheet where the information is automatically pulled from a database. It sums the total by Month but then it sums it twice by employee name and employee ID. I need a formula that will sum the column only with the numbers in it and not twice by employee name and employee ID. For example, in the table below, the first name is PIG, PORKY. I need a formula that say if the row has the word total it in, do not sum it. But sum rows without it. Can someone help me? ID Nbr Employee "Account" Mar Apr May Jun Jul013090 PIG, PORKY 1001 3 4 7 6 11013090 PIG, PORKY 1006 2 0 3 3 4013090 PIG, PORKY Total 5 4 10 9 15013090 Total 5 4 10 9 15013470 CHARMING, PRINCE 1006 158.5 112 200.5 215.5013470 CHARMING, PRINCE Total 158.5 112 200.5 215.5013470 Total 158.5 112 200.5 215.5014186 DOLL, DORA 1000 128 0 0 0 0014186 DOLL, DORA 1001 0 0 0 93.5 184014186 DOLL, DORA 1006 0 172 145 56 0014186 DOLL, DORA Total 128 172 145 149.5 184014186 Total 128 172 145 149.5 184014193 MUFFY, PUFFY 1001 130.2 168.2 154.5 168 184014193 MUFFY, PUFFY Total 130.2 168.2 154.5 168 184014193 Total 130.2 168.2 154.5 168 184014204 CAPPY, PAPPY 1000 120.5 0 0 0 0014204 CAPPY, PAPPY 1001 0 0 0 94.7 115014204 CAPPY, PAPPY 1006 0 135.5 168 72.5 0014204 CAPPY, PAPPY Total 120.5 135.5 168 167.2 115014204 Total 120.5 135.5 168 167.2 115

See More: Need a sumif formula

#1
December 3, 2012 at 20:22:11
 First, a posting tip...Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum. Thanks.As for your question, have tried something like this?=SUMIF(B1:B10, "<>Total", C1:C10)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions