Ravi Sir's Cards › Excel
Gift Register in Excel (card 2 of 2)
Revision card 2 for Gift Register in Excel: Total cash received: =SUMIF(C5:C12,"Cash",D5:D12) gives ₹12,803; Value of items: =SUMIF(C5:C12,"Item",D5:D12) gives ₹2,300. Includes an example data table.
Read card text
What this card says
2 for Gift Register in Excel: Total cash received: =SUMIF(C5:C12,"Cash",D5:D12) gives ₹12,803
Value of items: =SUMIF(C5:C12,"Item",D5:D12) gives ₹2,300. Includes an
Example
data table
Learn this in the lesson: Gift Register for a Function in Excel: Cash Gifts, Items and What We Gave Them Earlier