Excel

[svaydtla]

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

[#2 · Accepted 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. 

[#3]

@Riny_van_Eekelen Thank you! Totally worked!