SUM.IF and AVERAGE in same formula?

johannordgren

New Member
Hi y'all.

So I've made a SUMIF formula that follows:
SUM.IF(C:C;"Monday";D:D)

Im wonderng if i is possible to add an averagecount into this formula, so I dont have to use anoher column.
--> Count numer of recurring "monday" and count the average of the result from the formula above? You with me?

Thank you!

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

AlanY

Well-known Member
try the averageif() function

FormR

MrExcel MVP
You with me?

Hi, it's a confusing description! Do you want to count the rows where column C = "Monday" and column D = "average value in column D where column is a Monday"?

If so.
=COUNTIFS(C:C,"Monday",D:D,AVERAGEIFS(D:D,C:C,"Monday"))

If not - maybe have another go at describing what you want along with a scaled down example and the expected results for that example.

Replies
11
Views
130
Replies
4
Views
114
Replies
1
Views
80
Replies
6
Views
75
Replies
6
Views
82

1,109,360
Messages
5,528,235
Members
409,809
Latest member
VICKRAM

This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...