Excel - Using two counting formulas in one cell

Question

Hi,

I am looking to use two counting formulas in the one cell. I first need to use this formula =COUNTIFS('Enquiry List'!C1:C30,"Land & Property Lease/Rent") - this formula calculates the number of cells under the category "Land & Property Lease/Rent".

In the same cell, I then need to find out how many times the category "Land & Property Lease/Rent" was used during the whole month of May. I tried adding the additional formula onto the one above which now shows as =COUNTIFS('Enquiry List'!C1:C30,"Land & Property Lease/Rent"), ('Enquiry List'!A1:A30,">30/04/2024",'Enquiry List'!A1:A30,"<01/06/2024")

However, I end up getting a message saying there is a problem with the formula.

Can someone help?

Thanks,

Karen

Answer 1

Karen,

My bad, I beg your pardon.

=COUNTIF('Enquiry List'!C1:C30,"Land & Property Lease/Rent")&"/"&COUNTIFS('Enquiry List'!C1:C30,"Land & Property Lease/Rent",'Enquiry List'!A1:A30,">=01/05/2024",'Enquiry List'!A1:A30,"<01/06/2024")

If that doesn't produce the expected result I need to see your (sample) file.

Andreas.

Answer 2

Hi Andreas,

Thanks for your help. I tried your formula and I got this message:

Is there anything else you can suggest?

Answer 3

Karen, try this one:

=COUNTIFS('Enquiry List'!C1:C30,"Land & Property Lease/Rent") & "/" & ('Enquiry List'!A1:A30,">=01/05/2024",'Enquiry List'!A1:A30,"<01/06/2024")

You'll get an output like "100/20"

Andreas.