How can I add the values based the color of font and the date

P

Peter Gonzalez

Hello,

I wanted to know if it was possible to add the values of cells based on the
color of font. And while doing this I also need it to do it based on the date
in another cell.

Example: Sheet 1
Qty Date
Cell A1 288 (blue) Cell B1 4/13/2010
Cell A2 190 (red) Cell B2 4/13/2010
Cell A3 400 (blue) Cell B3 4/13/2010
" " 350 (red) " " 4/13/2010
" " 540 (blue) " " 4/12/2010
" " 175 (red) " " 4/12/2010
" " 225 (blue) " " 4/12/2010
" " 180 (red) " " 4/12/2010

My result should look like this if possible: Sheet 2
Column A Column B
4/12/2010 Total 765 (blue)
4/13/2010 Total 688 (blue)

Same Sheet 2 example with the (red) font

Your help is appreciated
Thanks,
Peter
 

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

Add values based on text color with the criteria of a date 7
How to add data from cells based on different criterias? 2
How to sum up the value in column based on a 5 day week period? 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
Sorting problem : "The sort reference is not valid..........." 3
Cell Color Recognition and Summing of Data Within a Specified Colo 1
Attempting to compare and deduct values based on date codes 3

Top