View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
O_o O_o is offline
external usenet poster
 
Posts: 2
Default SUMIF, One criteria multiple columns

Here's what I need to do:
A B C D F G .........N O............ V
Code va va va Code
12 L 520 250 M
13 L 500 700 M
.. R 1080 250 LM
.. COM 500 200 LM
.. O
31
=SUMIF(A12:V31,"LM",G12:G31:N12:O31)/1000

this formula works with the criteria from column A =SUMIF(A12:A31,"L"...
but it will not pull in the criteria from column V. What am I doing wrong?