Excel Formula Assistace

J

jezzad

Expert Member
Joined
Jan 2, 2013
Messages
1,605
Reaction score
784
Looking for help with the excel gurus on here.

I have three cells. First cell is a date, second cell is a name and third cell is a number. Like the below

1667997246449.png

I would like to count the number in cell C if the conditions are met in cell A and B.

i.e if the year equals 2021 and the name is Apple then count cell C and give me the total for all of these conditions.
 
Depends on the complexity of the conditions but COUNTIFS (or SUMIFS) is probably what you are looking for.

e.g. =SUMIFS(C:C, A:A, "2021/12/01", B:B, "Apple") will sum up all the values in column C where column A = 2021/12/01 AND column B = Apple (you might need to use a DATE unction for the condition on the date column, haven't tested the formula)
 
To cater for the criteria of 2021 and not 2021/12/01 please see below and rely on Formula in G2, leveraging the added Column B
1668081204868.png
 
Jehosefat said:
Depends on the complexity of the conditions but COUNTIFS (or SUMIFS) is probably what you are looking for.

e.g. =SUMIFS(C:C, A:A, "2021/12/01", B:B, "Apple") will sum up all the values in column C where column A = 2021/12/01 AND column B = Apple (you might need to use a DATE unction for the condition on the date column, haven't tested the formula)
Click to expand...

There will probably be more than apples, so you'll have to use a nested if

IF function - Microsoft Support

How to use the IF function in Excel to make logical comparisons between data values.
support.microsoft.com support.microsoft.com
 
Thanks for the input all, managed to get it working.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X