Sum with 2 criteria

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

Guest

I want to setup monthly summary sheets that uses data from another page i
have a formula that works however to make it work i have to select cells on
the ther page. What format do dates need to be in, every time i try a date i
think will make the formula work i get #NAME?

=SUMPRODUCT(--(Jobs!C8:C1200="Grade
C"),--(Jobs!G8:Jobs!G1200>=Jobs!G869),--(Jobs!G8:Jobs!G1200<=Jobs!G990),--(Jobs!I8:Jobs!I1200<=1),Jobs!J8:Jobs!J1200)

Where Jobs!G869 is the start date and Jobs!G990 is the finish date
 
Hi!

I'm not sure what you're asking?

One thing about your formula....

You don't have to repeat the sheet name if the range referenced is
contiguous:

Jobs!G8:Jobs!G1200>=Jobs!G869

Just use:

Jobs!G8:G1200>=Jobs!G869

That will at least shorten things a little and make it easier to read.

Biff
 
May not understand but here is a shot

--(Jobs!G8:Jobs!G1200>=--"2005-10-01"),--(Jobs!G8:Jobs!G1200<=--"2005-10-31"
)
 
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

Counting cells with multiple criteria 3
Finding Average with Criteria 4
NEED TO COUNTIF WITH TWO CRITERIA 3
counting with multiple criteria and wildcards 10
vlookup with a sum of array 4
Calculating %'s with IF and Sum/SumIF 12
Sum multiple cells if a column has a certain number in it 4
Sum single or duplicate rows with multiple criteria 3

Back
Top