How do i get excell to do if x:y=1 sum it if y:x=2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok I, trying to work with several colums of data i want to find out the
total of all the #1 in colum J that match with all the #1 in columQ. how do I
get excell to do that? I know I should be using IF(j3:j68=1),and(
q3:q68=1)sum plese help
 
Ok I, trying to work with several colums of data i want to find out the
total of all the #1 in colum J that match with all the #1 in columQ. how do I
get excell to do that? I know I should be using IF(j3:j68=1),and(
q3:q68=1)sum plese help
Click to expand...
You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the Excel newsgroup I would suggest you include your
Windows and Office version number in the message.
 
This is a news group for Access. I believe you really want a news group for
Excel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM - IF - AND 7
Excel Complex Summing 3
creating a calculated field 3
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
IF AND Nested Functions - Formula Not Working 0
excel sum values if cell matches a value 1
min if horizontal 0

Back
Top