O
O_o
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?
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?