0

I am in need of adding up any values in column E that coorespond to a particular month and category. E.g. Any amounts in January (from Column D) that are categorized as Income in Column A.

Here is an example of my data. Needing help with what formula will return the sum I'm looking for here.

Sample data1

Thanks for any help you can provide!

Improve this question
3
  • What have you tried?
    – Blindspots
    Commented Dec 19, 2022 at 2:47
  • (1) Please post textual data as text, not as an image.  (2) You’re more likely to get help if you give an example expected result for your example input data.  (I guess you want $700?)  (3) If you need to match substrings (matching “Main Income” and “Side Income” when you’re looking for “Income”), you need to say so.  (4) Look at  SUMIFS.
    – Scott - Слава Україні
    Commented Dec 19, 2022 at 3:21
  • @amdavis714 ,,,, others than SUMPRODUCT the SUMIFS can be used also !
    – Rajesh Sinha
    Commented Dec 19, 2022 at 4:12

1 Answer 1

Reset to default
1

Please check whether following formula is helpful.

=SUMPRODUCT((MONTH(D2:D4)=1)*(A2:A4="Income")*(E2:E4))

enter image description here

Improve this answer
1
  • ,,, easy & better one ,,,, +10 ☺
    – Rajesh Sinha
    Commented Dec 19, 2022 at 4:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .