Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding specific cells | Excel Worksheet Functions | |||
adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
ADDING CELLS WHICH ARE <> THAN OTHER CELLS | Excel Worksheet Functions |