Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to Sumif
I need to add the dollar amount in C2-C80 if the word in d2-d80 matches.
I need the total in g sum of c2-c80 if d2-d80=word (Total in g2-g13) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to Sumif
=SumIf(D2:D80,"=Word",C2:C80)
HTH -- Charles Chickering "A good example is twice the value of good advice." "Sherries" wrote: I need to add the dollar amount in C2-C80 if the word in d2-d80 matches. I need the total in g sum of c2-c80 if d2-d80=word (Total in g2-g13) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
SUMIF function help | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions |