Adding only cells with an X in it
 

Column G35 through G49 may or may not have the letter X in it based on the
product entered in Column A. Cells in Column R adds up the total of the
amounts in Column B times Column F. I need to have 2 totals. One that totals
only the cells in column G when there is an X showing and the second total
(same row - different column) adding all the cells in column R. I hope I am
making a clear question. I am sure the answer is simple, but I cannot figure
this one out. Thanks. Pete

Adding only cells with an X in it
 

Try

=COUNTIF(G35:G49,"X")

and

=SUMIF(G35:G49,"x",R35:R49)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=531208

Adding only cells with an X in it
 

Thanks for such a quick response. The =SUMIF formula was exactly what I
needed. Take care. Pete

"daddylonglegs" wrote:


Try

=COUNTIF(G35:G49,"X")

and

=SUMIF(G35:G49,"x",R35:R49)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=531208