View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
 
Posts: 273
Default sumproduct Column B based on Column A

Thanks! I know how to do formulas, I'm just not sure how to do this
particular formula. Could you give me an example?

"jamescox" wrote:


Excel itself will walk you through that.

Click on the fx symbol in the little area just to the left of the
formula bar. This opens an "Insert Function" window. In the 'search
for a function' box, type SUMIF, then click the Go button.

This highlights the SUMIF entry in the box below. Click on the OK
button and you will get a window that guides you through setting up the
formula, or you could click the Help on this function hyperlink/hotspot
to get help with more information on how to use SUMIF.

It's always good to check with this built-in guide to functions when
you are trying to do something...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111550