I've got the following setup of a table:
|| some-text-more (blank-12345)
What would the formula be if I wanted to make a SUMIF function where it gives the sum of the revenue in column B where the Criteria in column C appears in column A?
| ||Posted by scallebaut on |
You can use wildcards around the criteria to match partial text in the SUMIF function.
/5 from 1
If you have data down 20 rows, the formula in cell D2 is:
| ||Excel Business Forums Administrator|
| ||Posted by Excel Helper on |