Countifs while using filter

[datboyrib23]

Hey everyone-

I'm working on a file for my school to track what percentage of receipts have been receipts by multiple people within the office:

Format is as follows:

A B C D
Name Vendor Amount Receipt
John A 5 no
John B 10 yes
John C 15 no
Bill D 10 no
Sarah E 25 yes
Sarah F 5 no

Using countif formulas will yield a 33% return of receipts, however when i filter by person it's still 33%. Is there a formula I can use that will calculate the % returned in total and by person (so basically compatible with the filter)?? I need to get this done today if possible.

Help is greatly appreciated!!

Thanks much in advance.

[zeke varg]

Try this: Substitute your receipt column to 1 for "yes" and 0 for "no" (alternatively create a formula in the column E to the right as "=if("yes",1,0)).

Then in D1, use =subtotal(1,D3:D8).

(I tested in OpenOffice Calc, but Excel is basically the same and should work straight away)

Please Login or Register  to view this content.

[datboyrib23]

Worked. You're the greatest (and much smarter than me). Thanks!!

[zeke varg]

No probs! If you're satisfied with the workings, please remember to mark the thread as solved.

To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save