Something Missing
With M being the dollars made and D being the dollar sold a third range would
column F (Date range)
I want to find all the dates within a range (F2:F1000) and sum all the
dollars made within that range (M2:M1000) and divide the sum against the
total dollars sold for that range. If any number in column M is 0 I don't
want to add the corresponding cell in column D to the total, this throws my
total percentage off because the 0 is being included in the overall
performance.
"Herbert Seidenberg" wrote:
If you had this data in column M and D
M D
1 59
2 48
0 26
4 55
what would be your desired result?
|