Need help, COUNTIF

BuddyGSD

New member
Joined
Oct 24, 2016
Messages
6
Reaction score
0
Points
0
I would like a formula that will sum based on payment type on the box that reads Sum By Category.

I will entering data on Payment Type and Payment Amount and it would be great to see the total amount separately .
 

Attachments

  • Excel.png
    Excel.png
    36.6 KB · Views: 19
You mean SUMIF.

Assuming your first category is in H3, then in I3 enter formula:

=SUMIF(F:F,H3,G:G)

This will sum column G where column F match value in H3.

You can copy down formula to get sum of other categories.
 
Back
Top