Sumif query
 

I need help with the following:

I need to search column A for all instances of "N1", in column F is the
value for that row.....

....what can I use to get the total value of all instances of N1?????

Sumif query
 

Have you looked in the help index for SUMIF?

--
Don Guillett
SalesAid Software

"AndyO_UK" wrote in message
...
I need help with the following:

I need to search column A for all instances of "N1", in column F is the
value for that row.....

...what can I use to get the total value of all instances of N1?????

Sumif query
 

Yep....its rubbish....hence my online query.

"Don Guillett" wrote:

Have you looked in the help index for SUMIF?

--
Don Guillett
SalesAid Software

"AndyO_UK" wrote in message
...
I need help with the following:

I need to search column A for all instances of "N1", in column F is the
value for that row.....

...what can I use to get the total value of all instances of N1?????

Sumif query
 

=SUMIF(A:A,"N1",F:F)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"AndyO_UK" wrote in message
...
I need help with the following:

I need to search column A for all instances of "N1", in column F is the
value for that row.....

...what can I use to get the total value of all instances of N1?????

Sumif query
 

How so?

SUMIF(range,criteria,sum_range)

Range is the range of cells you want evaluated.

Criteria is the criteria in the form of a number, expression, or text that
defines which cells will be added. For example, criteria can be expressed as
32, "32", "32", "apples".

Sum_range are the actual cells to sum.


--
Don Guillett
SalesAid Software

"AndyO_UK" wrote in message
...
Yep....its rubbish....hence my online query.

"Don Guillett" wrote:

Have you looked in the help index for SUMIF?

--
Don Guillett
SalesAid Software

"AndyO_UK" wrote in message
...
I need help with the following:

I need to search column A for all instances of "N1", in column F is the
value for that row.....

...what can I use to get the total value of all instances of N1?????