Thread: sum values in a col only if value in next col is desired value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default sum values in a col only if value in next col is desired value
"u999rbm" wrote in message
...
add numbers in col A if values in col B = M only
Excel 2003


Hi U,

If a worksheet formula would suit, try:

=SUMIF(B1:B100,"=M",A1:A100)


---
Regards,
Norman




Reply With QuoteReply With Quote