SOLVED

Excel

Occasional Contributor

Need to calculate the number of days in a spreadsheet that the sales price was below the average sales price. Any suggestions?

2 Replies
best response confirmed by svaydtla (Occasional Contributor)
Solution

@svaydtla That could be something like this:

=SUMPRODUCT(--(prices<AVERAGE(prices)))

where "prices" refers to the range containing the daily prices.

If this doesn't make any sense, perhaps best to upload a schedule that accurately represent your real life data. 

@Riny_van_Eekelen Thank you! Totally worked!