Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sumif 1

Status
Not open for further replies.

nbay001

IS-IT--Management
May 21, 2007
12
US
This SHOULD be a no easy but it's not working. I have Excel 2003

In column A I have Text. If the value in column A = "PROJECTION" THEN ADD IT UP, OTHERWISE DON'T. Column B has the $$ values.

So my Sumif formula is =SUMIF(A1:A800,"=PROJECTION",B1:B800)

Am I missing something?

Thanks so much for your help.

Paula

 
hi,
[tt]
=SUMIF(A1:A800,"PROJECTION",B1:B800)
[/tt]


Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Thanks much.

It works.

!! Excellent.

Paula
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top