B
Ben12956
Hi,
I'm trying to set it up so that all figures which match the same two
criteria are all added up together, using only one formula.
Both criteria are based on Text - for instance "English", and "September"
So far I've got this for both, but can't work out how to combine them both.
=SUMIF(A:A,"English",G:G)
&
=SUMIF(B:B,"September",G:G)
Is there any way of getting it so that the overall sum of all entries
matching both criteria is shown?
Thanks in advance.
I'm trying to set it up so that all figures which match the same two
criteria are all added up together, using only one formula.
Both criteria are based on Text - for instance "English", and "September"
So far I've got this for both, but can't work out how to combine them both.
=SUMIF(A:A,"English",G:G)
&
=SUMIF(B:B,"September",G:G)
Is there any way of getting it so that the overall sum of all entries
matching both criteria is shown?
Thanks in advance.