Home

Combination of formula - SUMIF/IF and colour count

Kate Smith
Occasional Visitor

So I'm trying to combine a colour count formula with another, I got the colour count formula from here; https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/how-can-i-use-sumif-with...

 

I'd like to combine it with a SUMIF or IF formula, to say if something is one one column, then look for the colours and count what it in the cells.

 

So the colour count formula that works is; =SUMBYCOLOR('Cohort 1'!O:O,10,FALSE)

A SUMIF that also works is; =SUMIF('Cohort 1'!D:D, "Medical Physics", 'Cohort 1'!O:O)

 

Essentially I'm trying to group together costs for certain programmes in certain academic years. The programme name is in a column, the fee is in the cell of a different column and the academic year is signified by colour.

 

Open to any suggestions on other ways to do it as well. The only other way I thought was to do an IF AND – IF it’s Medical Physics AND the colour is X, but I can’t find a way of including the colour is X (I’ve used the Color Palette).

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies