adding and counting Help!!

  • Thread starter Thread starter alexm999
  • Start date Start date
A

alexm999

Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe
doing the sum of dollar amount
 
alexm999 said:
Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe
doing the sum of dollar amount.
Click to expand...

Assuming that dates are true dates...

=SUMPRODUCT(--(CodeRange=101),--(AdvertisingRange="TV"),--(TEXT(DateRange,"yyyy.mm")=TEXT(X2,"yyyy.mm")),DollarRange)

where X2 houses a true date, formatted as 2004.10.01 for cosmetics
 
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 is not correct after adding calculated fields 4
Rounding Effecting Sum 2
summing two columns of different data 4
Conditional Sum date range 2
IF Statement 4
Pivot table formatting - colors 3
Match formula 2
Sumif comparing dates in criteria 1

Back
Top