GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Scotty.T · 08-08-2006, 02:31 AM

Try this, if I understand you correctly this will do it, just expand the ranges and change the criteria word

=SUM(SUMIF(C$2:C$37,"Advertising",D$2:D$37))

The smiley in the last bit is a colon and D obviously

08-08-2006, 02:31 AM
Scotty.T Confirmed User Join Date: Nov 2004 Location: Scotland Posts: 1,062	Try this, if I understand you correctly this will do it, just expand the ranges and change the criteria word =SUM(SUMIF(C$2:C$37,"Advertising",D$2:D$37)) The smiley in the last bit is a colon and D obviously __________________ . Last edited by Scotty.T; 08-08-2006 at 02:33 AM..